citrix4Move Datastore from SQL 2000 to SQL 2005

Posted by citrix on February 4, 2010
Nathan Baylor I have a Citrix farm with 6 Windows 2003 servers running Presentation Server 4.0. They are all connected to a SQL 2000 Enterprise datastore.

I want to move the datastore from SQL 2000 Enterprise to SQL 2000 Standard. The current datastore is using the master database, but when i move the datastore i want it to use its own database.

Here is what I think needs to be done…..

1. Create a new database on on the SQL 2005 server with a compatibility level of (80)
2. Run dsmaint /migrate on one of the Presentation servers.
3. Run dsmaint /configure with the new MF20.dns created on each of the servers.
4 Restart the IMA service.

Copy of current MF20.dsn
ODBC
DRIVER=SQL Server
UID=sa
DATABASE=master
WSID=citrixserver_1
APP=Citrix IMA
SERVER=databaseserver_1
Description=databaseserver_1

Copy of NEW MF20.dsn
ODBC
DRIVER=SQL Server
UID=sa
DATABASE=citrix_farm
WSID=citrixserver_1
APP=Citrix IMA
SERVER=databaseserver_2
Description=databaseserver_2

Is that basically it in a nutshell or am I missing anything? Also when you run the dsmaint migrate command does it copy the database to the new server or does it move it. Because I would like to test it on 1 server before I move all of them over.
Category: Citrix4