restructuring DBs
Current scnerio
we have a database DB1 and it is replicating (using transactional replication) most of the object in database DB2 (but not all objects).
Database DB2 also have few it own objects which does not exist in database DB1.

problem
now the problem is whenever we deploy our changes we have to make changes in both the databases separately (DB1 & DB2).

requirement
requirement is that, we want to make database DB2 a strict copy or subset of database DB1 means all the objects which are available in database DB2 should also be there in DB1.

the objects of database DB2 should get replicated from database DB1 only. there should not be any independent object in Database DB2, so that there will only be one point of deployment changes which will be database DB1.

kindly help to suggest what should be the best approach to achieve requirement which is mentioned above.
April 29th, 2015 10:58am

If replication goes one way - use transactional replication. Otherwise use bi-directional transactional replication or merge.
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 5:25pm

thanks for the reply, but bigger challange for now seems to sync both the DB to make them strict subset. currrrenty few objects are there on DB1 which does not exist in DB2 and few objects are there on DB2 which does not exist in DB1.
May 4th, 2015 1:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics