Hey guys I have to setup transactional replication using the Central Publiser Model for a BES(BlackBerry) Server.
One of the guidelines from reading is to make sure that all tables have a primary key.
When handling identity columns to be replicated would you
A). Use the not for replication option for identity columns
B). Create a composite key using the identity column and any other column so that identity ranges do not need to be managed.
I'm pre-planning to see what is going to be the best way to set it up and also to administer in case of challenges that might arise.
I have obtained as much data about the enviroment etc... as possible so far....