Tables with FK and not NFR

Last Post 25 Jun 2006 04:08 AM by TRACEYSQL. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
probani
New Member
New Member

--
18 Jan 2006 12:21 AM
Hello all,

I'm having problem with transactional replication - to replicate referencial intergity as well. I have database with 360 tables with 416 FK constraints containing "enforce relationship for replication". I want to use the transactional replication as part of disaster recovery plan, but how can replicate referencial intergrity to the subsriber as well? Is enabling NOT FOR REPLICATION on every foreign key the only solution or it can be done in another way?

If the only solution for replication refencial intergrity to the subcriber is through NOT FOR REPLICATION, then which is the easiest way to enable NOT FOR Replication on every FK?

Regards,
ProBani.
TRACEYSQL
New Member
New Member

--
24 Jun 2006 02:56 PM
can you explain a bit more

our erp does not come with primary keys it comes with indexes....

so in order to use replication we have to put primary keys on all our tables .....

are you saying we do not to have primary keys ? and replication can still occur.
TRACEYSQL
New Member
New Member

--
25 Jun 2006 04:08 AM
oh i want the file tables to be replicated...

Merge will still do the same as transactional ? and still copy the data across

If that is so i look into merge.


Acceptable Use Policy
---