Hi all, I'm in the middle of a conversion so pressed for time. Real simple.
I set up and ran a DTS package to copy data from two identical tables from
server A event_history table to server b Event_history table. The server b
table was empty at the time and created from script. Both tables had a
column named seqno which is an identity.

My question is when the data is copied from server A to server B, will it
preserve the seqno (identity) column from server a or assign it a new one
based on the seed on server B event_history. The DTS package ran
successfully, but I can't go back to check since the other database has been
overwritten. I didn't set up anything differnt than a standard copy on the
DTS package. Any guidance would be appreciated.
Thanks.
Don
Vector Security Inc.

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)


"Don" <Don (AT) discussions (DOT) microsoft.com> wrote

Darren is correct.

An empirical test which shows the IDENTITY column from source is ignored by
the destination IDENTITY column, meaning it starts over (1,2,3 etc.).

Tom Bradshaw


--
Message posted via http://www.sqlmonster.com

Thomas Bradshaw via SQLMonster.com wrote:
Using the correct settings you can actually do it either way around you
would like.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com