Mark, You only have to migrate the first server (w/ the Access Data Store). After that, all you need to do is copy the .DSN file and run the correct DSMAINT CONFIG (params..) command from each server. Don't forget to stop & restart the IMA service on each box! Robert L. Hoesly, CCA (XP/1.8) Senior Analyst Advanced Technology Group - End User Computing Services Cerner Corporation 2800 Rockcreek Parkway Kansas City, MO 64117 Phone: (816) 201-2271 -----Original Message----- From: Mark [mailto:thin@xxxxxxxxxxxxx] Sent: Wednesday, October 30, 2002 10:35 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Migrate to SQL 2000 I am getting ready to migrate my datastore from Access to SQL. I have read through citrix's doc CTX773628, searched here, and the Citrix forumn. What I am looking for is any gotchas. Can I migrate one server to start and do the rest in a couple of days, or does it all have to be at once? We are Win2k / MF XPe Fr1/sp1 (we have one server that is Fr2) -- Mark ********************************************** This weeks Sponsor NetX Inc Thin Client NetX Develops XP and NT Embedded Thin Client Solutions, Easy to Configure, Extremely Secure, and Remotely Managed. Check out our recently updated website at http://www.netxinc.com *********************************************** Visit Jim Kenzig of thethin.net at the Emergent Online Booth #26 at Citrix Iforum 2002! Register now at: http://www.citrixiforum.com/registerNow.html *********************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link. http://thethin.net/citrixlist.cfm CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. ---------------------------------------- -- *********************************************** Visit Jim Kenzig of thethin.net at the Emergent Online Booth #26 at Citrix Iforum 2002! Register now at: http://www.citrixiforum.com/registerNow.html *********************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link. http://thethin.net/citrixlist.cfm