June 30, 2015 at 11:58 am
Hi,
We have a "main" SQL 2014 server who imports XML files using SSIS in a datacenter. In remote sites (which are warehouses), there is an instance of SQL 2014 Express. A merge replication is setup, as every operations done on each site must be "forwared" to the main database, as some XML files are generated as output for an ERP system.
Now, the merge replication replicate all the data to the server on each sites. But a specific site don't need the data of every other sites, only the data relevant to itself (which is the warehouse code). Is there a way to replicate only the data relevant to each individual sites to the subscribers? Or is there a better way than replication to accomplish this?
thanks for your time and help
July 1, 2015 at 3:12 am
Hi,
Without knowing too much of your architecture, it's difficult to say.
Merge replication is designed to keep data synchronised so whatever data you put in the merge should stay in synch. If you don't want this then I would suggest merging is not the answer.
It sounds like each site has specific needs when it comes to data. So is splitting the data into site specific databases of tables an option. You might need some extra processing at the main server but it might limit the amount of data being sent to each site.
Graeme
July 1, 2015 at 4:43 pm
this can be accomplished by setting up filters on specific columns.
Our primary ERP database has business data for all locations.
We have many sites.
Each site is a different branch plant.
When replicating, we filter on the branch plant to determine who gets what.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply