Link to home
Start Free TrialLog in
Avatar of Avatar261
Avatar261

asked on

Moving Data Store to New Server

I have purchased a dedictaed SQL server and want to migrate the data store to this server.

The server will not have Citrix installed or indeed be part of the Farm.

What is the best way of doing this and how do i point the servers that are in the Farm at the datastore?
Avatar of darrengp
darrengp

you need to run the dsmaint utility

http://www.thin-world.com/MFCommands/dsmaint.htm


should give you all the info you need let me know if I can help more

Darren
You should be done in no time, this is a fairly common need.

This is an excerpt from http://www.citrix4ge.de/ctxsffaq/index.htm#dsmig

If you go to this link, scroll down to 31

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Create a new SQL Database on the SQL Server ("sa" as user)
Create DSN file on the citrix server for the SQL Database and save it to
"%ProgramFiles%\Citrix\Independent Management Architecture" let's
say as SQL.DSN
Open command line and run DSMAINT

dsmaint migrate /srcdsn:"%ProgramFiles%\Citrix\Independent Management Architecture\MF20.dsn" /srcuser:citrix /srcpwd:citrix /dstdsn:"%ProgramFiles%\Citrix\Independent Management Architecture\SQL.DSN" /dstuser:sa /dstpwd:

on every other server in the farm copy the SQL.DSN to the server and run

dsmaint config /user:sa /pwd: /dsn:"%ProgramFiles%\Citrix\Independent Management Architecture\SQL.DSN"
MetaFrame XP Advanced Concepts - Farm Maintenance
CTX677542
Advanced Concepts Guide for MetaFrame XP FR3
CTX102497
Migrating a MetaFrame XP Access Database to Oracle 9i
CTX102551
 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Darren...didn't mean to step on your toes there.
no worries we were posting at the same time :)

don't forget on each server to run dsmaint reacreatelhc or you could get false alerts for can't connect to datastore (must stop ima service to run)

Avatar of Avatar261

ASKER

does it matter though that the new SQL server will not have Citrix installed?
no not at all best not to I have found
after i have migrated the DSN to SQL.DSN and run the config on the other servers, how do the servers then know to look at the new SQL server for the datastore?

or do i specify in the new SQL DSN the server name?
the dsmaint config (.dsn file) will have the new database in
hmmm i dont quite follow, surely you have to tell it somewhere where the new SQL server is?
when you create the new .dsn file or alter the existing you put the details of the new sql server along with the username and password information.
Do you require details on creating the dsn?

Darren
please, if thats ok with you
You there Darren?
ASKER CERTIFIED SOLUTION
Avatar of darrengp
darrengp

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you can copy the dsn file to each server after you create / change it on the first one