This posting is provided "AS IS" with no warranties, and confers no rights.
I am using merge replication and want to partition the data using different
ranges for identitiy columns in combination with the NOT FOR REPLICATION
I have enter these different ranges on the subscriber manually BEFORE I
register these servers as subscribers, as afterwards one is NOT allowed to
make schema changes on tables participating in a merge replication.
So I do all the necessary manual editing on the tables of my prospective
Then, when it comes to register this server as a subscriber, I am not sure
which of the following snaphsot options I should select:
1.) Drop and re-create the existing table
2.) Delete the data in the existing table
3.) Leave the table as it is
Wouldn't I loose all of my schema changes on the tables, if I choose 1?
Wouldn't I miss the merge replication triggers and guid-columns, which are
normally created during the course of the inital snapshot, if I choose 2 or
Thanks in advance
8. dbase and XP