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 |
|
rogerwithnell
Starting Member
5 Posts |
 Posted - 2005-08-25 : 20:40:23
|
| I use the DTS wizard to import my database from the operational server to my test server.All columns in all tables that are datatype int that have their identity set to Yes have their identity changed to No.Any help very much appreciated. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-08-26 : 02:28:27
|
| You have to check the option to copy Identity columns.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
rogerwithnell
Starting Member
5 Posts |
Posted - 2005-08-26 : 05:46:08
|
| I'm new to all this. All I know about DTS is how to run the DTS Wizard!Where do I check the option to copy Identity columns. |
|
|
|
rogerwithnell
Starting Member
5 Posts |
Posted - 2005-08-26 : 06:28:29
|
| I found the check box "Enable Identity Insert" on the "Column Mapping and Transformations" page accessed for each table from the "Select Source Tables and Views" page within the wizard, but this does not preserve the column identity.So, I still need your help!Many thanks in anticipation. |
|
|
|
rogerwithnell
Starting Member
5 Posts |
Posted - 2005-08-26 : 13:30:17
|
| I have resolved my problem.On the "Specify Table Copy or Query" in the DTS wizard I select "Copy objects and data between SQL Server databases", rather than "Copy tables and views from the source database" it works fine. |
|
|
|
|
|
|
Indentity lost when using DTS