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.
| 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 |
|
|
|
|
|
Possible or Impossible - Replication and Mirroring