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?
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?
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\Ind ependent Management Architecture" let's
say as SQL.DSN
Open command line and run DSMAINT
dsmaint migrate /srcdsn:"%ProgramFiles%\Ci trix\Indep endent Management Architecture\MF20.dsn" /srcuser:citrix /srcpwd:citrix /dstdsn:"%ProgramFiles%\Ci trix\Indep endent 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%\Citri x\Independ ent 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
~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ ~~~~~~~~~~ ~~~~~~~~~~ ~~~
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\Ind
say as SQL.DSN
Open command line and run DSMAINT
dsmaint migrate /srcdsn:"%ProgramFiles%\Ci
on every other server in the farm copy the SQL.DSN to the server and run
dsmaint config /user:sa /pwd: /dsn:"%ProgramFiles%\Citri
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)
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)
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
ASKER
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?
or do i specify in the new SQL DSN the server name?
the dsmaint config (.dsn file) will have the new database in
ASKER
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
Do you require details on creating the dsn?
Darren
ASKER
please, if thats ok with you
ASKER
You there Darren?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can copy the dsn file to each server after you create / change it on the first one
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