I had a Presentation 4.0 farm using an old SQL 7 server for it’s datastore which I wanted to migrate onto a new SQL 2005 server. This is how I did it beating in mind the article found here;

1. Backed up the datastore database on SQL 7 and restored it directly on the SQL 2005 server.
2. Shutdown all Citrix Pres servers apart from licence/data collector server.
3. Stopped the IMA service on this server
4. Copied the MF20.dns file located by default in c:\Program Files\Citrix\Independent Management Architecture
5. Edited the original MF20.dns and changed the SERVER= setting to the new server.
6. Shutdown the old SLQ 7 server.
7. Re-started the IMS service.
8. Check logs for any sign of datastore errors.
9. Repeated steps 3 – 8 on all other Citrix servers.
10. Set up maintenance task on SQL 2005 to backup the datastore DB. You might have to make the DB version 80 or upwards compatible (options setting on the properties of the DB) for it to appear in the list of Db’s available.