Silhouette
IS-IT--Management
We are planning to use the replication feature of SQL Server 7 to replicate database records from one site to another. The tables that will be replicated contain primary keys that are auto-generated (digits only). Each site allows users to insert, update, and delete records. Records from one site need to be replicated on the other site and vice-versa.
How can we successfully replicate the contents of these tables w/o violating the unique key constraint? We were thinking of putting a prefix in generating the primary keys but this will require us to make major alterations on our existing production databases. Are there other ways?
How can we successfully replicate the contents of these tables w/o violating the unique key constraint? We were thinking of putting a prefix in generating the primary keys but this will require us to make major alterations on our existing production databases. Are there other ways?
