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-08-09 : 09:14:03
|
| Arfat writes "Hi Folks,I am having a database on SQL Server 2000,I want to get this database on SQL Server 2005,To do this we have our Create table scripts of our database, and Alter Table Script to apply the constraints like Foreign key and unique key which we run after creating the table.I run the create table script which created the table on SQL 2005,I use the import Export tool from SQL 2005 to copy the data from SQL 2000 to new SQL 2005.I am having a table called Customer which is having CustID column with identity(1000,1)the Table Customer on SQL 2000 is already having custID between 1-1000 which have been kept for internal customer.but when i copy the data from 2000 to 2005 using Import Export the iD changes and new id are assigned starting from 1000 and so on.I tried switiching on and off from enable identity while exporting.I tried using DTS of SQL 2000 and it work fine for exporting data to SQL 2005 without effecting the Identity column and retaining the original value.Which mean there has to be something in Import Export of SQL 2005 to control this.Can any 1 reply to this.Best Of regards.Arfat Chougulay" |
|
|
|
|
|
Import / Export SQL 2000 to SQL 2005