moving the store 1

[terry712]

i'm am looking at the advanced concepts guide and am a bit confused.
what i have is 5 servers in a farm and one hosts the datastore in access. i want to move this to a sql server that is not in the citrix farm.

so i create a sql db.
the dsn connection says use mf20.dsn but this already exists - can i call it something else or save to somewhere else or?

it then says after that to copy the dsn that you crate to each of the servers and then run dsmaint config - when you have a look at this it seems kind of server specific
should i make these up on each of the servers or is it safe to copy - as my original will surely be created on the one hosting the current access db

any help appreciated - wish i had set it to sql when i built it

 

[bran2235]

It has been a while since I have done this.. but here are my notes:

*** Command line utility used to migrate a Metaframe XP Data Store from Access to SQL server. ***

FIRST
Create a File data source connection pointing from original machine to new SQL database called MF20SQL.dsn.

SECOND
Migrate the data store:

dsmaint migrate /srcdsn:"c:\program files\citrix\independent management architecture\mf20.dsn" /dstdsn:"c:\program files\citrix\independent management architecture\mf20sql.dsn" /dstuser:mfxp /dstpwdassword

THIRD
Reconfigure IMA to use the new data store:

dsmaint config /user:mfxp /pwdassword /dsn:"c:\program files\citrix\independent management architecture\mf20sql.dsn"

Hope this helps... you can find lots of notes on this at Citrix web site...


Brandon

 

[terry712]

yep cheers
i have completed it now anyway

but that is more or less identical to how i did it
except i moved the default mf20.dsn to a temp location , created the new one with same name and then migrated from the temp location

worked a treat

thanks