Re: FK for tables out of the publication. - 02-01-2006 , 03:04 AM
you can use pre-snapshot and post-snapshot scripts to handle FKs outside of
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
Re: FK for tables out of the publication. - 02-01-2006 , 03:25 AM
What you need to do is change the article properties to keep the existing
table intact. Right click on your publication, select properties, click on
the articles tab, and then select the snapshot tab, and select keep existing
table unchanged. Note that this might duplicate data, so you may need to use
the delete data option and have cascading deletes on the subscriber.
Looking for a SQL Server replication book?
Looking for a FAQ on Indexing Services/SQL FTS
"??? ?????" <nospameyalSchapira (AT) hotmail (DOT) com> wrote