Here's what I do. I use the SQL script generator to build a script with all my indexes constraints and defaults in it. I use it to create everything EXCEPT the constraints (foreign keys) on the new blank DB. Then I run DTS to import the data, then I run the "constraints" portion of the script. It sounds like a lot of work, but it's really not - the script generator makes it very easy.
-mk -----Original Message----- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 9:57 AM To: CF-Talk Subject: OT: SQL Server Export Hey guys, whenever i do an export of tables from one DB to another, it never copies the table attributes, such as default value, for example. I have many instances where the default value is needed. Can someone let me know how to do this? maybe i missed a step in the DTS thanx ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
