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 2012 Forums
 Replication (2012)
 Possible or Impossible - Replication and Mirroring
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Zangetsu
Starting Member

South Africa
6 Posts

Posted - 06/25/2014 :  17:04:12  Show Profile
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

USA
37466 Posts

Posted - 06/25/2014 :  17:04:49  Show Profile  Visit tkizer's Homepage
Please don't cross-post.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000