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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
