When exporting to the other database, instead of using: "Copy tables and views from the source database"
try using: "Copy objects and data between SQL Server databases" Adam. > -----Original Message----- > From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 8: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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
