Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › MS SQL Server Merge Replication
New Posts  All Forums:Forum Nav:

MS SQL Server Merge Replication

post #1 of 5
Thread Starter 
Hey Guys!
I've been trying to configure a merge replication using Microsoft SQL Server 2008, I have 4 databases (lets call them A B C D), that I'm trying to keep synced between each other, so I created a fifth database( E ) where I'm replicating the data. That part is working, my E database is being updated and seems to be ok, however, despite having my replication as merge the source tables (A through D) are not being updated when my centralized table is. How can I do that?

Some info about my setup:
Each database contains 1 table only.
Main Server ( E ): Configured as Distributor of itself, with 1 subscription for each server (A - D), all pointing to the same local database in E.
Servers ( A through D ): Distributor configured for server E, each with a publication of the database.

If there is a better way of doing these please let me know. Keep in mind all I need is my A, B, C and D databases to have the same information. I created my fifth database because I will need (in the near future) a local database (@server E) to process the information.
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
post #2 of 5
I'm not up to speed on MS SQL Server any longer, but I've got a question? Are all these DBs on different servers in different locations around the country/world? Must each be capable of independent operation should any one fail? If the configuration must be as you've stated, and I don't know the MS SQL Server term for it, would be what's called master-to-master replication. In other words, a change on any node is replicated to all other nodes.
The Money Trap
(17 items)
 
  
CPUMotherboardGraphicsRAM
i7-5820K ASUS X99-Deluxe 2 x EVGA GTX980 SLI 4 x 4GB Corsair Vengence DDR4 2400 
Hard DriveHard DriveHard DriveOptical Drive
Games = Crucial 256GB M4 SSD OS = Samsung 256GB 830 SSD Backup Western Digital HDDs  Samsung 223 
CoolingOSMonitorPower
Phanteks PH-TC-14PE  Win 7 x64 Ultimate  Dell U2412M 1920x1200 Antec TPQ 1200W 
CaseOther
Cooler Master HAF 932 UPS: APC BackUPS XS1500 
  hide details  
Reply
The Money Trap
(17 items)
 
  
CPUMotherboardGraphicsRAM
i7-5820K ASUS X99-Deluxe 2 x EVGA GTX980 SLI 4 x 4GB Corsair Vengence DDR4 2400 
Hard DriveHard DriveHard DriveOptical Drive
Games = Crucial 256GB M4 SSD OS = Samsung 256GB 830 SSD Backup Western Digital HDDs  Samsung 223 
CoolingOSMonitorPower
Phanteks PH-TC-14PE  Win 7 x64 Ultimate  Dell U2412M 1920x1200 Antec TPQ 1200W 
CaseOther
Cooler Master HAF 932 UPS: APC BackUPS XS1500 
  hide details  
Reply
post #3 of 5
Thread Starter 
Yes, 5 databases (if counting the new one created E) are located on different locations. And yes, I need all of them to contain the same data, the faster they are kept in sync the best.
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
post #4 of 5
MS' version of master-to-master replication:
"The addition of peer-to-peer transactional replication in SQL Server 2005 simplifies the implementation of a bi-directional transactional replication topology, where the replication stream flows both ways. "

See following link, download the .pdf and start on page 4: http://www.google.com/#output=search&sclient=psy-ab&q=microsoft+sql+server+2008+replication+step+by+step&oq=Microsoft+SQL+Server+2008+replication&gs_l=hp.1.1.0l3j0i22i30.2065.7589.0.15014.13.6.0.7.7.0.136.755.0j6.6.0...0.0...1c.1.14.psy-ab.Nzl2OxCNaIo&pbx=1&bav=on.2,or.r_qf.&bvm=bv.47008514,d.dmQ&fp=335d3dd7a8b6c25f&biw=1494&bih=1013
The Money Trap
(17 items)
 
  
CPUMotherboardGraphicsRAM
i7-5820K ASUS X99-Deluxe 2 x EVGA GTX980 SLI 4 x 4GB Corsair Vengence DDR4 2400 
Hard DriveHard DriveHard DriveOptical Drive
Games = Crucial 256GB M4 SSD OS = Samsung 256GB 830 SSD Backup Western Digital HDDs  Samsung 223 
CoolingOSMonitorPower
Phanteks PH-TC-14PE  Win 7 x64 Ultimate  Dell U2412M 1920x1200 Antec TPQ 1200W 
CaseOther
Cooler Master HAF 932 UPS: APC BackUPS XS1500 
  hide details  
Reply
The Money Trap
(17 items)
 
  
CPUMotherboardGraphicsRAM
i7-5820K ASUS X99-Deluxe 2 x EVGA GTX980 SLI 4 x 4GB Corsair Vengence DDR4 2400 
Hard DriveHard DriveHard DriveOptical Drive
Games = Crucial 256GB M4 SSD OS = Samsung 256GB 830 SSD Backup Western Digital HDDs  Samsung 223 
CoolingOSMonitorPower
Phanteks PH-TC-14PE  Win 7 x64 Ultimate  Dell U2412M 1920x1200 Antec TPQ 1200W 
CaseOther
Cooler Master HAF 932 UPS: APC BackUPS XS1500 
  hide details  
Reply
post #5 of 5
Thread Starter 
Great! I got the file, gonna test it tomorrow morning! I'll post again afterwards !
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › MS SQL Server Merge Replication