-
Problem with Import/Export Wizard
I have read your articles and I got one question about the SQL Server Import and Export Wizard in MS SQL 2005.
It seems that in some cases, the Wizard do not copy ID’s even if I select the “Enable identity insert”
One of these cases is when I have already run a script to create the database schema before I start the wizard.
If I don’t run a script to create database schema before I start the wizard, then I will not get the keys transferred to the new database.
Do you know why this can happen and if this is meant to be a feature in the MS SQL 2005 or is Microsoft using another way to copy databases with identities and keys in this version?
Last edited by Kjetil; 01-18-2007 at 08:13 AM.
Reason: added SQL version
-
Did you define ID column as identity column? Can you post schema?
-
Originally Posted by rmiao
Did you define ID column as identity column? Can you post schema?
I did define ID column as identity column.
Sorry that I cannot post schema. That information can not be posted on forum. I find it strange what happened.
-
Tried copy objects in SSIS?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|