SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication with branches
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dtoffe
Starting Member

Argentina
1 Posts

Posted - 11/22/2012 :  16:33:56  Show Profile  Reply with Quote
Hi all,

We need to have a replication setup between a central Sql Server 2005 and one 2005 Express in every branch. The database structure is the same, but about half the tables need to be partitioned by branch id.
We need non partitioned tables to be download only to the branches, but the partitioned ones we need to have bidirectional synchronization. Either transactional with updatable subscribers or merge would be OK for us, we don't need instant updates, just frequently enough will do.
For example assume a table Orders, with a BranchId field. We need the central database to be updated with all the orders originating from all branches, but every branch must only be sync'ed with its own orders.
My first plan is to have one publication for each branch, exposing all non partitioned tables as download only, and the partitioned tables filtered by BranchId as in "WHERE BranchId = 'Branch1'", etc.
I've gone so far as to have one subscription from one branch working OK, but I can't find a way to create similar publications for the other branches, I get errors no matter what I try except if I don't set a filter by branch, and this is not the behaviour I want.
I believe I'm having problems with the correct setting of the Article properties "Synchronization Direction" and "Partition Options", but after trying every possible combination, I'm starting to believe the scenario I'm trying to setup is not possible.
Is it possible to have two-way synchronization between Sql Server and Express in 2005 ?? Where can I find more detailed explanation of the articles' properties and the setup of different scenarios similar to the one I'm attempting ?

Thanks all,

Daniel
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000