April 29, 2015 at 4:56 am
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 29, 2015 at 11:21 am
Which version/edition of SQL Server are you using? If "DB2" is really just for read-only purposes, and aussiming that it's hosted on a different server, an Always-On availability group could be a good option to explore.
April 29, 2015 at 11:35 am
you can replicate schema changes to secondary's. please review msdn
https://technet.microsoft.com/en-us/library/ms147331(v=sql.105).aspx
May 3, 2015 at 11:28 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply