Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2005-07-05 : 12:01:41
|
| When I choose DTS>Import and import table / data from 1 DB to another, I want to retain my table settings, such as Primary columns and Identity.How can I do this when using Import/Export Wizard??Currently, after choosing the tables, I click on Transform button and choose 'Enable identity insert' checkbox.But this still does not insert Identity into my tables.Any idea wha I am missing??reggards |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-05 : 16:37:40
|
| hopefully, someone will have the answer.Its 30 tables to import and I cannot change the primary key of every table manually |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-05 : 18:05:40
|
| The easiest way would be to use Enterprise Manager to script out create table scripts for all the tables you want to copy over to the new database. Be sure to select the options to create all indexes, table constraints, defaults, primary keys, foreign keys, triggers, full-text indexes, and permissions.After you create the empty tables, just use DTS to copy over the data.CODO ERGO SUM |
|
|
|
|
|
|
|
|
Keeping table settings when importing tables