Moving Data Store to New Server

Avatar261
Avatar261 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
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
ITDharamPresident

Commented:
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
 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ITDharamPresident

Commented:
Darren...didn't mean to step on your toes there.
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Commented:
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)

Author

Commented:
does it matter though that the new SQL server will not have Citrix installed?

Commented:
no not at all best not to I have found

Author

Commented:
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?

Commented:
the dsmaint config (.dsn file) will have the new database in

Author

Commented:
hmmm i dont quite follow, surely you have to tell it somewhere where the new SQL server is?

Commented:
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

Author

Commented:
please, if thats ok with you

Author

Commented:
You there Darren?
Commented:
yep sorry

admin tools
data sources (odbc)
select file dsn
browse to where you existing metaframe dsn is (default is program files     then citrix    then indepentdent management architecture
hightlight the dsn click configure
select the server
click though and ensure you have the correct username and password and correct database selected

then use the dsmaint config command on each server

dsmaint config /user:username /pwd:password /dsn:complete path including file name

then run dsmaint recreatelhc on each server to resync the local host cache

hope this makes sense

Darren

Commented:
you can copy the dsn file to each server after you create / change it on the first one

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial