Hi,
Which type(s) of publications keep the relationships and constraints when
the schema and data is pushed over to the subscriber ?
Ben,
have a look at the article properties form - DRI constraints is an option in
each type of replication. It'll take the FKs if both the PK and the FK
tables are in the same publication.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment