March 8, 2005 at 12:40 pm
Hi.
I'm newbie to replication. I'm trying to set up simple snapshot replication of some (not all) tables to another database. These tables have foreign key constraints. When I define article defaults, I select "Delete all data in existing table" and "Include declared referential integrity". Everything works fine, except one thing: tables in subscription database loose their foreign keys! File TableName_number.dri has only "SET QUOTED_IDENTIFIER ON" line.
I'm using Sql 2000 Developer SP3. Any ideas? I will be very gratefull, since I've lost the whole afternoon with this issue.
March 9, 2005 at 2:52 am
Are you sure that you have foreign keys defined?
If so as a work around script them and run them in manually on the subscriber.
March 9, 2005 at 5:30 am
apply the fk's using the post snapshot command.
However, when I include DRI on my snapshot publications, I do get the DRI transfered. I am not sure what is happening on your system.
--
Hilary Cotter
Looking for a SQL Server replication book?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply