Very cool, thanks. ~Jason -----Original Message----- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 10:12 AM To: CF-Talk Subject: RE: TSQL Script to replicate a db?
You could use the Scripting wizard in the Enterprise manager. To do this Select the DB right click, and select Script DB, this gives you the necessary wizard to get everything, SP's, tables, Indexes etc. Jason Lees Development Team Leader National Express Systems. -----Original Message----- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 14:47 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
