Dan G. Switzer, II wrote: > 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? >
If you are really just copying the whole database (not just the schema) and then making a couple of changes, you might find it easiest to just restore a database backup as the new database and then make your changes. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
