Overclock.net › Forums › Software, Programming and Coding › Networking & Security › Seperate Database Locations Synch
New Posts  All Forums:Forum Nav:

Seperate Database Locations Synch

post #1 of 8
Thread Starter 
As a programmer, my knowledge on networks is limited so i'm turning to the OCN network gurus.

Imagine a scenario where we have 3 different site locations for a company. Each site location will have it's own web server and a database (SQL Server 2005) that contains information for each site's web server and each site contains the exact same website's for each location. Is it possible to synch the data from the database from all 3 locations with the information from all locations?


TIA.
post #2 of 8
Yes. It's a common feature of all Window Server platforms: 2008, Exchange, SQL, etc.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Cisco Cisco Cisco Cisco 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Cisco Cisco Cisco Cisco 
  hide details  
Reply
post #3 of 8
More specifically, it will generate triggers on your tables and sync the changes to the other servers. You can get creative with this and have 2 failover db's for each location (as you have 3 db's). Just a few lines of code for each webserver connection to the other db's if the server db goes down.

Quote:
Originally Posted by scottsee View Post
Yes. It's a common feature of all Window Server platforms: 2008, Exchange, SQL, etc.
    
CPUMotherboardGraphicsGraphics
i7-980X (batch#3003B331) Gigabyte X58A-UD7 Sapphire Radeon R9 290 Diamond Radeon HD 5970 
RAMHard DriveOptical DriveOS
24 GB Crucial C300 (256GB SSD) + Seagate XT 7200 2TB LG BH10LS30 (Blueray writer) Windows 7 Professional for Partners 8/18/09 
MonitorKeyboardPowerCase
Samsung 1 x 2493HM 2 x 2494HM Logitech G110 Silverstone Strider ST1500 Cosair 800D 
MouseMouse Pad
Logitech G9 steelseries 
  hide details  
Reply
    
CPUMotherboardGraphicsGraphics
i7-980X (batch#3003B331) Gigabyte X58A-UD7 Sapphire Radeon R9 290 Diamond Radeon HD 5970 
RAMHard DriveOptical DriveOS
24 GB Crucial C300 (256GB SSD) + Seagate XT 7200 2TB LG BH10LS30 (Blueray writer) Windows 7 Professional for Partners 8/18/09 
MonitorKeyboardPowerCase
Samsung 1 x 2493HM 2 x 2494HM Logitech G110 Silverstone Strider ST1500 Cosair 800D 
MouseMouse Pad
Logitech G9 steelseries 
  hide details  
Reply
post #4 of 8
scottsee and sparkle nailed it pretty much, essentially what you are wanting is Data replication, which is a feature of software. Might be better getting help from a Server admin and how Domain Controllers replicate. I would try the MS forum section.
The Raven
(16 items)
 
  
CPUMotherboardGraphicsGraphics
i7-2600K Gigabyte GA-P67A-UD5-B3 EVGA GTX 570 SC EVGA GTX 570 SC 
RAMHard DriveOptical DriveCooling
16GB G.SKILL Ripjaws X 1866 Samsung 840 Pro  iHAS324 - Lite-On DVD-RW Noctua NH-D14 
OSMonitorMonitorKeyboard
Windows 10 ASUS VN248 ASUS VN248 Logitech G510 
PowerCaseMouse
XFX 850W BE SILVERSTONE RV02B-EW Logitech MX518 
  hide details  
Reply
The Raven
(16 items)
 
  
CPUMotherboardGraphicsGraphics
i7-2600K Gigabyte GA-P67A-UD5-B3 EVGA GTX 570 SC EVGA GTX 570 SC 
RAMHard DriveOptical DriveCooling
16GB G.SKILL Ripjaws X 1866 Samsung 840 Pro  iHAS324 - Lite-On DVD-RW Noctua NH-D14 
OSMonitorMonitorKeyboard
Windows 10 ASUS VN248 ASUS VN248 Logitech G510 
PowerCaseMouse
XFX 850W BE SILVERSTONE RV02B-EW Logitech MX518 
  hide details  
Reply
post #5 of 8
Thread Starter 
Awesome, thanks a bunch everyone.
post #6 of 8
How big is the databases? Is it over 500mb?
post #7 of 8
Thread Starter 
Quote:
Originally Posted by Spooony View Post
How big is the databases? Is it over 500mb?
Yeah, it's way over 500 MB and more like ~800GBs and growing. Why?
post #8 of 8
Quote:
Originally Posted by Wr3ckin_Cr3w View Post
Yeah, it's way over 500 MB and more like ~800GBs and growing. Why?
You should have a serious look at some of the excellent commercial offerings out there


Red Gate Software's SQL Compare and SQL Data Compare - excellent tools, highly recommended! You can even compare a live database against a backup from another database and synchronize the data - pretty nifty!
.

ApexSQL's SQL Diff and SQL Data Diff

They all cost money - but if you're serious about it, and you use them in your daily routine, they're paid for in no time at all well worth every penny.
The only free option you have in SQL Server 2008 would be to create a link between the two servers and then use something like the MERGE statement (new in SQL Server 2008) to transfer the data. That doesn't work for structural changes, and it's limited only to having a live connection between the two servers.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Networking & Security
Overclock.net › Forums › Software, Programming and Coding › Networking & Security › Seperate Database Locations Synch