I have a Database which contains about 15 tables that 10 of them should be replicated to another database which its schema is "EXACTLY" same with the publisher. The 5 tables that are not planed to publish, have no rows all over the time (indeed the subscriber
DB is just a template DB that should be synchronized becuase of some reasons)...
At snapshot definition I just set each table to Truncate All rows at initialization level. But the problem was that it drop all indeces automatically and FK Constrains which causes the different schema in subscriber DB. So I dcided to set to Copy ALL of
related objects (indeces,FKs,cluster indeces,triggers ,...) at initialization level. But the problem is with 5 tables that are not published when all their relations with the other 10 tables will be droped at initialization level....Beside of all these problems
I get FK constraint error at initialization time...
Also I should mentioned that my DB version is 2000 SP4.
Did I miss or misunderstood something? or should I choos another solution? or some problem in SQL 2000 and should migrate to 2005 or 2008?
Thanks for your appreciation
View Complete Post