[THIN] Re: Migrate SQL Datastore to another SQL Server

That would be correct.   However, there are some shortcuts that could make your transition a little faster.

 

If the username and password remains the same on the new SQL Server you can simple just modify the existing .DSN file (change the servername) and restart IMA service.   You only need dsmaint config if the accounts changes.

 

You can also migrate the database using the dsmaint migrate command as well.

 

Joe

 

From: thin-bounce@freelists.org [mailto:thin-bounce@freelists.org] On Behalf Of Angela Smith
Sent: Wednesday, January 07, 2009 4:23 AM
To: thin@freelists.org
Subject: [THIN] Migrate SQL Datastore to another SQL Server

 

Hi

I will be migrating my CPS 4 farm SQL DB to another SQL Server.  SQL versions are not changing.  Im simply moving the DB from a single SQL Server to a SQL cluster.  Ive never moved a Datastore so I was hoping someone could validate these steps for me.

1. Back up the existing farm database and restore the database to the new SQL Cluster.

2. From a Citrix Server, create a new DSN file that points to the database restored in Step 1

3. Execute the dsmaint config command on the server with the new DSN file.

dsmaint config /user:domain\userid /pwd:password /dsn:"c:\program files\citrix\independent management architecture\mf20.dsn"

4. Stop and restart the IMA Service.

5. Verify that the server is using the correct DSN by checking at the following registry setting:

HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\IMA\DataSourceName

6. If the IMA Service started successfully, copy the DSN file created in Step 2 to all servers in the farm.

7. Execute the dsmaint config command to change the IMA service configuration on all servers in the farm.

8. Stop and restart the IMA service on all servers in the farm.

9.  Create new Published Application.  Ensure DB is working correctly.


In relation to the steps above, I have a few questions:

1) Is there a Preferred server order I should follow?  Should the Zone Data Collector be done last?
2) If I copy the DSN to all servers, wont the DSN be wrong on all servers as the information within the file will be specific to the first server it was copied from.  IE WSID field
3) The Server in question which I am migrating off also holds the RMSummaryDB.  Whats the best way to migrate this?

Thanks
Angela

---

Download free Holiday emoticons today! Messenger's gift to you!