Hi, It's fine for going from SQL to SQL. Regards, Rick Ulrich Mack Volante Systems Ltd 18 Heussler Terrace, Milton 4064 Queensland Australia. Ph: +61 7 3246 7704 email: rmack@xxxxxxxxxxxxxx web: www.volante.com.au -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Jeff Durbin Sent: Tuesday, 2 November 2004 2:40 PM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Updated IMA datastore migration procedure? DSMAINT MIGRATE is for moving from one database platform to another, so I presumed you couldn't use it to go from SQL to SQL, although I've not actually tried it. > -----Original Message----- > From: thin-bounce@xxxxxxxxxxxxx > [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Tony Lyne > Sent: Monday, November 01, 2004 12:08 PM > To: thin@xxxxxxxxxxxxx > Subject: [THIN] Re: Updated IMA datastore migration procedure? > > Theres the way Jeff mentioned to do it. > > I just done a DS migration for a customer to a new SQL server > a couple of days ago and used the DSmaint migrate command > then dsmaint config and had no problems. > > Tony Lyne > Senior Systems Engineer > Computerland Central > P O Box 1470 > PALMERSTON NORTH > Telephone (+64) 06 3537300 > Facsimile (+64) 06 3566800 > Mobile (+64) 0274 720696 > E-mail Tony.Lyne@xxxxxxxxxxxxxxxxxx > Internet http://www.computerland.co.nz > CAUTION: This e-mail message and accompanying data may > contain information that is confidential and subject to > privilege. If you are not the intended recipient, you are > notified that any use, dissemination, distribution or copying > of this message or data is prohibited. If you have received > this e-mail in error, please notify me immediately and delete > all material pertaining to this e-mail. Thank you. > > > > > -----Original Message----- > From: Jeff Durbin [mailto:techlists@xxxxxxxxxxxxxxxx] > Sent: Tuesday, 2 November 2004 6:57 a.m. > To: thin@xxxxxxxxxxxxx > Subject: [THIN] Re: Updated IMA datastore migration procedure? > > Actually, it should be much more simple than what I once > posted. You should be able to: > > 1. Copy/move the SQL data store database to a new SQL server > 2. If it's in the same domain, and you want to use the same > credentials, ensure that the account is a DB_OWNER of the > data store database on the new server. > 3. Modify the MF20.DSN files on all MF servers. If the account > hasn't changed, just stop the IMA, change the SQL server name > in the DSN file (server=), and restart the IMA. If the account has > changed, stop the IMA, run DSMAINT CONFIG with the (username, > password, and DSN file (with the entire path to it, even if > you execute DSMAINT from the folder the DSN file is in), and > restart the IMA. > > JD > > > -----Original Message----- > > From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] > > On Behalf Of Landin, Mark > > Sent: Monday, November 01, 2004 9:56 AM > > To: thin@xxxxxxxxxxxxx > > Subject: [THIN] Updated IMA datastore migration procedure? > > > > Back in 12/03, Jeff Durbin posted a procedure for migrating an IMA > > datastore from one server to another. Have there been any > refinements > > or updates to this procedure? We are needing to do a migration and > > haven't had much luck so far... > > > > --- > > The T drive is not backed up > > ******************************************************** > > This Weeks Sponsor Emergent Online ThinCity Conference Join us at > > ThinCity 2004: The 1st Annual Emergent OnLine Technology Conference > > http://www.ThinCity.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 > > > > ******************************************************** > This Weeks Sponsor Emergent Online ThinCity Conference Join > us at ThinCity 2004: The 1st Annual Emergent OnLine > Technology Conference http://www.ThinCity.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 > > ******************************************************** > This Weeks Sponsor Emergent Online ThinCity Conference Join > us at ThinCity 2004: The 1st Annual Emergent OnLine > Technology Conference http://www.ThinCity.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 > ******************************************************** This Weeks Sponsor Emergent Online ThinCity Conference Join us at ThinCity 2004: The 1st Annual Emergent OnLine Technology Conference http://www.ThinCity.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 ##################################################################################### This e-mail, including all attachments, may be confidential or privileged. Confidentiality or privilege is not waived or lost because this e-mail has been sent to you in error. If you are not the intended recipient any use, disclosure or copying of this e-mail is prohibited. If you have received it in error please notify the sender immediately by reply e-mail and destroy all copies of this e-mail and any attachments. All liability for direct and indirect loss arising from this e-mail and any attachments is hereby disclaimed to the extent permitted by law. ##################################################################################### ******************************************************** This Weeks Sponsor Emergent Online ThinCity Conference Join us at ThinCity 2004: The 1st Annual Emergent OnLine Technology Conference http://www.ThinCity.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