RE: Migrating sqlservers
If you are creating an *exact* replica of the original SQL Server, the easiest way is to: 1) stop SQL server on the Source Machine 2) Zip the data directory 3) transfer the zip file to the destination machine 4) Install patch dest machine to exact config as source (don't worry about users or permissions) 5) stop the dest SQL server 6) rename the dest data folder 7) unzip file to the dest data location 8) start SQL server on dest Job complete w/ an EXACT replica. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
Can you transfer the SQL server by connecting them via the internet? I know that this works with MS SQL, not sure about other databases. -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
First off have an id created that is on the new and the old server. Then delete out all ids with the exception of that db and make that id dbo of the database via sp_changedbowner oldowner, newowner Then have a complete backup of the db zipped up and sent to you then use sp_detachdb to detach the database from that server have that also sent to you. First try to restore the full backup if the does not work then use sp_attachdb on the new server. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
whoa, interesting idea. I was thinking more allong the lines of copying the db via enterprise manager. Is this a bad idea? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 1:06 PM To: CF-Talk Subject: RE: Migrating sqlservers First off have an id created that is on the new and the old server. Then delete out all ids with the exception of that db and make that id dbo of the database via sp_changedbowner oldowner, newowner Then have a complete backup of the db zipped up and sent to you then use sp_detachdb to detach the database from that server have that also sent to you. First try to restore the full backup if the does not work then use sp_attachdb on the new server. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
Could be long and painful. I have built and transferred many servers using this and have had zero problems. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:07 PM To: CF-Talk Subject: RE: Migrating sqlservers whoa, interesting idea. I was thinking more allong the lines of copying the db via enterprise manager. Is this a bad idea? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 1:06 PM To: CF-Talk Subject: RE: Migrating sqlservers First off have an id created that is on the new and the old server. Then delete out all ids with the exception of that db and make that id dbo of the database via sp_changedbowner oldowner, newowner Then have a complete backup of the db zipped up and sent to you then use sp_detachdb to detach the database from that server have that also sent to you. First try to restore the full backup if the does not work then use sp_attachdb on the new server. Joshua Tipton -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating sqlservers
On 7/5/02, Brian J. LeRoux penned: whoa, interesting idea. I was thinking more allong the lines of copying the db via enterprise manager. Is this a bad idea? I do it with Enterprise Manager all the time. It takes 5 minutes. 1. Create an empty SQL database on the new server. 2. Set the properties to whatever they'll be. 3. Create a user and/or assign the user to the new database with DBO privileges. 4. In Enterprise Manager, right click the old database and choose All Tasks/Export Data. 5. The Import/Export wizard will open. Click Next. 6. Your server and database should be chosen. Click Next. 7. Choose the SQL Server where the new database is. You'll obviously need this set up in your Client utility. 8. Enter the new user and password, click Refresh, choose the new database and click Next. 9. Click the Copy Objects and Data radio button and click Next. 10. UN-check the Use Default Options box, then click the Options button. 11. UN-check Copy Database Users and Roles and click OK, then click Next. 12. Run immediately should be checked. Click Next. 13. The summary will appear. Just be sure you're exporting from the correct database to the correct database. Click Finish and wait. This may take awhile depending on the size of the database and the connection between the two. Hopefully you won't get any errors. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
