Many thanks for your help, as it happens, I found the farm is using direct connections to the SQL Database, but they are not displayed under ODBC, only as a DSN in the IMA Directory, with a local cache defined as an Access Database Phil -----Original Message----- From: Ron wilson [mailto:rwilson@xxxxxxxxxx] Sent: 13 November 2002 12:38 To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: IMA Datastore question If you go out to the citrix's site there you can download an administration guide. If you browse to the section Metraframe Commands you'll find that there is a dsmaint command. This command has a flag /migrate that you can use to migrate from an access database to a SQL database. Hope this helps Ron Wilson >>> John.Rowlandson@xxxxxxxxxxxxx 11/13/02 05:32AM >>> i would do it offline, just in case... also decide if you are going = direct or indirect to the sql data store... citrix have a whitepaper i think about migrating to sql from access or = its in the advanced admin guide john -----Original Message----- From: Newman, Phil [mailto:Phil.Newman@xxxxxxx] Sent: Wednesday, 13 November 2002 9:30 PM To: 'thin@xxxxxxxxxxxxx' Subject: [THIN] IMA Datastore question I'm sure this is a simple question, but I just want to check. I have inherited a new Xpe farm, which appears to be running an Access Database based system. I say this as there is no mention of SQL based = DSN's with the ODBC configuration. I would like to move toward a direct connected SQL Config. Is the best = way to do this, to set up an appropriate SQL Database, and then migrate the servers to use this? What is the best way forward, and is this an evening/weekend job, or can = it be done server by server during the day? Many thanks, Phil Newman ***********************************************=20 For Archives, to Unsubscribe, Subscribe or=20 set Digest or Vacation mode use the below link. http://thethin.net/citrixlist.cfm *********************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link. http://thethin.net/citrixlist.cfm *********************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link. http://thethin.net/citrixlist.cfm *********************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link. http://thethin.net/citrixlist.cfm