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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-12 : 11:18:38
|
| Mayuresh writes "Is there any way you can restore primary key using the export data option in SQL server 2005 ? My destination database has all the tables with the identity set after I run the export data utility but for some reason the primary key is lost and I have to manualy select them.Thanks" |
|
|
arf_chou
Starting Member
6 Posts |
Posted - 2006-07-18 : 04:20:48
|
Hi,I am also facing the same problem,So if u find any solution let me know.I am trying import data from SQL Server,and i am having identity column set in tables in my databaseexample Customers => CustID identity(1000,1)I am having CustID from 1 to 1000 set for internal Customer,When i Import the data the CustID is reset and start the ID from 1000 onward which causes a problem in linking with orders tabel which belong someother customers,I tried using SQL Server 2000 DTS to export it to SQL 2005 and it works fine without manuplating the ID column (CustID).Which means there is should be someting in Import Export of SQL 2005 which does this, I tried enabling and disabling the identity column option in SQL 2005 Import / Export wizard but nothing happend.Can anyone help regarding this |
 |
|
|
|
|
|
Export Data in SQL Server 2005