Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darkmakers
Starting Member
3 Posts |
 Posted - 2010-10-11 : 16:28:16
|
| 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?Thanks a lot |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
darkmakers
Starting Member
3 Posts |
Posted - 2010-10-12 : 07:49:04
|
| Thanks I'll give it a try! |
 |
|
|
darkmakers
Starting Member
3 Posts |
Posted - 2010-10-12 : 22:41:06
|
quote:
Originally posted by tkizer
Manually sync the data from the master database, and then setup replication and uncheck the option to initialize the subscription. Then you're now setup to get the new data.
That did it thanks, easier than I thought! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Replicating to a pre-populated table