Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-20 : 08:05:27
|
| Michael writes "HiI am consolidating data from several servers onto one server using transactional replicationThe problem is that the PK on the source tables contains overlapping values which cannot be changed (ie invoice numbers).I would like to add another field to the subscriber database tables and change the primary key on the subscriber to include this new field (ie invoice_no + lab_id = PK)I would like to avoid changing the PK on the publisher tables if at all possible.when i run the replication it drops the constraints on the subscriber table, adds the data and re-applies the constraints from the PUBLISHER. Is it possible to make it re-apply the constraints for the EXISTING TABLE ?any idead would be greatly appreciatedcheersmike" |
|
|
|
|
|
Primary Keys & Transactional Replication