Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

Integer identity value handling in export / import

Hi,

I have a question regarding export / import when you have tables with autonumber (identity) columns as primary surrogate keys. Does export / import retiain the values of these columns so that referential integriy is not broken?

Charles

[244 byte] By [Challe] at [2008-2-25]
«« NT service returns 80070003
»» Unresolved external when compiling xxx_i.c (IID and CLSID) using /clr
# 1
Yes!
Depending on how you import the data, make sure you choose the correct option that you wish to explicitely insert your "own values" into an IDENTITY column.
You might want to check BOL for SET IDENTITY_INSERT or BULK INSERT...KEEPIDENTITY or BCP -E. There is also some equivalent when you use DTS, but since I don't use DTS, I don't know what option to check there.
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
FrankKalis at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2

I am Hitesh.

I have the same issue. While exporting/importing data (from SQL 2005 to SQL 2005) IDENTITY column values get altered..this way my referencial integrity gets broken that is not good at all....I am familier that using COPY WIZARD & Backup/Restore this can be avoided but I want to know ONLY for DTS import/export wizard....Will you please help me....it's very very very urgent to me.

Thanks.

to_hitesh at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified