Save as a dts package and then you can edit the information. They have a visual interface- add dependencies/etc. I suggest making some db copies and play with it
-----Original Message----- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 9:47 AM To: CF-Talk Subject: TSQL Script to replicate a db? Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export tool and export it to another client's db. The problem is that each time I do this I have to go back and set up the autonumber fields on every single table which takes a long time. Does anyone know of a way to take my existing db and use a wizard to create either a stored procedure or a bunch of sql statements that will recreate all of the tables and relationships of my db? Thanks, Jason ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
