Replication newbie

[Stunner01225]

Im trying to set up my first replication using snapshot publication and a pull subscription. I can get the data to move across, but when I have the primary and foreign keys attached to the subscription table the replication fails.

How do I work around this?

 

[Stunner01225]

I have solved this now. Under article I set the snapshot to delete all data rather than drop the table.

Regards

Stunner

 

[JayKusch]

Just make sure to keep tabs on your TLog situation with DELETING these transactions. If there are a bunch, your TLog could grow substantially rather quickly since deletes are a logged event as opposed to a single logged event of dropping the table. Just a friendly FYI!

Thanks

J. Kusch