Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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
38200 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  
 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.04 seconds. Powered By: Snitz Forums 2000