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.

 All Forums
 SQL Server 2012 Forums
 Replication (2012)
 Possible or Impossible - Replication and Mirroring

Author  Topic 

Zangetsu
Starting Member

6 Posts

Posted - 2014-06-25 : 17:04:12
Hi all, hope I am posting this under the correct "Forum Topic"

I need to know if the following could be possible or not, as I am quite new to SQL Server (Know the basics).

First off, this is my setup:
(1) 7 Individual SQL Servers with its own Master DB(Head Office and 6 Branches across the State)Networked via the internet (VPN)

(2) Each branch containing their own data (Products, Stock on hand, Product prices etc.) All 7 master databases are identical with the exception of quantity values, the only difference would be the values of physical stock on hand per branch and prices may differ.

Question 1
I had the idea to setup table replication between Head office and Branches. Would it be possible for Head Office to update the dbo.Product_Price table - Price_Value and then be replicated down to the 6 individual branches so they would not also need to manually update after each price change occurs.

Question 2
At the same time Head office would like to see the Stock on Hand values per branch, I was wondering if it might be work to create 6 Sub-Databases on the Head Office SQL Server and setup table mirroring between branches and sub-databases(Sub-Database per branch).

Please let me know if this could work or if I have not explained it clear enough.

Regards

Always trying to make the impossible, possible

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-25 : 17:04:49
Please don't cross-post.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -