Here is a little something that I found.
http://www.sharewareconnection.com/export-schema-to-sql-for-sql-server.htm Doug B. ----- Original Message ----- From: "Dan G. Switzer, II" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, January 29, 2007 5:28 AM Subject: Copying specific company data to a new database... > I have a MSSQL database w/a lot of tables. I've got to copy all of a > company's data from one database into a brand new database. The database > should have all its foreign keys/primary key relationships defined (with one > exception.) > > I can write scripts by hand, but that will take a while. There's a lot of > work involved (disabling primary keys, reseeding indexes, etc.) > > Does anyone know of any good tools that will allow me to migrate the data to > a new database? > > Thanks, > Dan > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4