I have an interesting scenario where I need to replicate from a system/master database to a number of subscribers, each of which have independent and unique data already existing in the table that needs to be replicated to. So basically the master database
contains only system level data, and this system level data should be pushed out to all subscribers, each of which may have existing nonsystem data already in the replicated tables.
As an example assume I have the following tables:
Create table FormTemplate (id int, templateName varchar(100), companyId int null)
Create table Form(id int, templateId int, companyId int not null)
The FormTemplate table may have rows in the system database to represent system level form templates (eg a null companyid) - all of these system formtemplates should be pushed across to all the subscribers so its possible to create a Form entry in the subscriber
referencing the templateId of the system template that has just been replicated. At the same time, each of the subscribers may have its OWN FormTemplate records defined which will exist in that database and ONLY in that database - this data should remain after
synchronisation with the system database.
Assuming that identity range management isnt an issue, is it possible to achieve this using replication or is this kind of behaviour not really supported?
View Complete Post