Replication In SQL Server 2005?
-
Hi all, I am facing a problem on whether using Transactional replication or Merge replication technique in SQL Server 2005. In my senario, i have 2 database which located in one sql server,named D1 and D2. Now, i would like to sync some of the table between these 2 database, and the data will frequently update/delete/insert by user into D1 or D2 and user should have the latest data for proceed operation. So, may i know which technique should be use in this senario? Any suggestion or tips are welcome. Note: And what if the 2 database are located in different server(different location)? thanks in advance cocoonwls
-
Hi all, I am facing a problem on whether using Transactional replication or Merge replication technique in SQL Server 2005. In my senario, i have 2 database which located in one sql server,named D1 and D2. Now, i would like to sync some of the table between these 2 database, and the data will frequently update/delete/insert by user into D1 or D2 and user should have the latest data for proceed operation. So, may i know which technique should be use in this senario? Any suggestion or tips are welcome. Note: And what if the 2 database are located in different server(different location)? thanks in advance cocoonwls
I had the same scenario and ended up using transactional replication @ 2 hour intervals. I was going @ 15 minute intervals with no issues but I wanted to have some latency in the event the source DB has some problems it gives me time to shut down the replication. I didn’t use merge because if one DB gets hosed or corrupted they both get hosed. I hope that helps.
Regards, Hulicat
-
I had the same scenario and ended up using transactional replication @ 2 hour intervals. I was going @ 15 minute intervals with no issues but I wanted to have some latency in the event the source DB has some problems it gives me time to shut down the replication. I didn’t use merge because if one DB gets hosed or corrupted they both get hosed. I hope that helps.
Regards, Hulicat
Hi Hulicat, Thanks for your helping hand. Is Transactional replication bidirectional? i need to do sync for both side, that mean either D1 or D2 update, then both of them are update. And the interval time is my piority concern, i have to do it as fast as possible to allow user to use the latest data, may be in 30sec or even per transaction. thankx in advance. regards cocoonwls
-
Hi Hulicat, Thanks for your helping hand. Is Transactional replication bidirectional? i need to do sync for both side, that mean either D1 or D2 update, then both of them are update. And the interval time is my piority concern, i have to do it as fast as possible to allow user to use the latest data, may be in 30sec or even per transaction. thankx in advance. regards cocoonwls
-
Hi Hulicat, Thanks for your information.I got it ;) .But then is there any solution/suggestion to prevent the problem you were mentioned in your first post? regards cocoonwls