I have a replication scheme where we have transactional (snapshot) replication between Publisher and Subscriber.
Subscriber should never be modified (IE: no inserts/updates/deletes) that need be synchronized at the Publisher. The subscriber essentially contains a subset of publisher tables that are used by a UI in a read only fashion.
Now, the publisher tables have identity columns. The client insists that the replication can replicate the tables to the subscription and not copy over the identity column (IE: When the snapshot is loaded ... the tables in the Sub are dropped
and re-created ... Boom ... we have an identity column)
Is there ANY way to load the initial snapshot and NOT have to column copied over but NOT as an identity column????
I have not seen anything in the publication properties that would prevent the column from being copied over as identity.
Any ideas ... anyone ... Bueller?
Thanks for any information ...
View Complete Post