My publisher database has identities set on columns.
We load the snapshot into the subscriber by dropping all the tables and creating them as new.
We are concerned with bringing over the identities on these columns may cause issues. We would like to just copy the same values from the publisher to the subscriber.
Are we being overly concerned about something we do not need to? Is it guaranteed to be the same value copied over, even if it is an identity column?
Thank you for any information.
P.Eng., CISSP, MCAD
View Complete Post