David, It's simple.. Backup your access dsn file Dsmaint backup command Then create a new dsn throught the odbc administration console = connecting to the sql db, IMASQLDB.DSN Then DSMaint migrate /srcdsn:"c:\progra~1\citrix\indepe~1\mf20.dsn" /srcuser:citrix /srcpwd:citrix /dstdsn:"C:\progra~1\Citrix\indepe~1\IMASQLDB.dsn" /dstuser:IMADBUSR /dstpwd:AABBCCDD Now the migration has taken place, one thing left to do, connect the ima service to the new dokter timmerslaan C:\Program Files\Citrix\INDEPE~1>DSMaint config /user:imadbusr = /pwd:AABBCCDD /dsn:"c:\progra~1\citrix\indepe~1\imasqldb.dsn" After this you need to restart the ima services and your running on sql db.... The current Datastore should be migrated last....for obvious reasons... Hope this works...otherwise look it up at citrix.com Met vriendelijke groeten / With kind regards Rob Beekmans Technical Consultant A-Tree Automatisering Business Phone: +31 24 6452000 Business Fax: +31 24 6450463 Business website: http://www.a-tree.nl Business E-mail: R.Beekmans@xxxxxxxxx Private E-mail: RobBeekmans@xxxxxxxxxxxxx Private website: http://joulupukki.nl =20 -----Oorspronkelijk bericht----- Van: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] Namens David Teague Verzonden: woensdag 10 maart 2004 21:11 Aan: thin@xxxxxxxxxxxxx Onderwerp: [THIN] Moving the IMA datafile to SQL Guys, When we setup our network here my boss did not want to put the citrix = db on SQL so we are using the access db, not since he has went to his = citrix class he wants to change it to an SQL based db, is there a way to do = this and keep the pub apps? How would I point an existing farm to the new sql based db? Thanks! David Teague TMTsoftware Support Analyst 919.493.4433=3D09 ******************************************************** This weeks sponsor Emergent Online. Emergent OnLine is the leading server-based computing consulting = integration firm in the nation. Emergent OnLine delivers expert=20 consulting services you can depend on. http://www.go-eol.com ********************************************************** Useful Thin Client Computing Links are available at: http://thin.net/links.cfm *********************************************************** For Archives, to Unsubscribe, Subscribe or=20 set Digest or Vacation mode use the below link: http://thin.net/citrixlist.cfm ******************************************************** This weeks sponsor Emergent Online. Emergent OnLine is the leading server-based computing consulting integration firm in the nation. Emergent OnLine delivers expert consulting services you can depend on. http://www.go-eol.com ********************************************************** Useful Thin Client Computing Links are available at: http://thin.net/links.cfm *********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thin.net/citrixlist.cfm