schema updates with sql server merge replication
MiguelTheMagic
Posts: 2 Bronze 1
Hi,
we have to sync quite a lot of databases of our customers. For example, we have a customerwho has 40 branches all over Germany. To keep all the databases in sync we use sql server merge replication (one master, 40 sync clients) which works very well. Now the problem is, that when we apply schema updates to the master database with SQL Packager 7 no database in the branches get the schema updates and the sync process is stopped at all. How can we overcome this?
It seems to us that schema updates provided with SQL Packager 7 can not be detected by sql server merge replication.
Regards,
Michael
we have to sync quite a lot of databases of our customers. For example, we have a customerwho has 40 branches all over Germany. To keep all the databases in sync we use sql server merge replication (one master, 40 sync clients) which works very well. Now the problem is, that when we apply schema updates to the master database with SQL Packager 7 no database in the branches get the schema updates and the sync process is stopped at all. How can we overcome this?
It seems to us that schema updates provided with SQL Packager 7 can not be detected by sql server merge replication.
Regards,
Michael