October 21, 2009 at 8:19 am
hello everyone,
first of all... I'm more of a .net developer than a ms sql server expert. And right now this is a problem 😉
In our company we have serveral MS SQL 2005 database server. Some of them are organized in clusters. Most of them are not. The two sql servers of my concern are even in two different windows domains.
Let's call them source and destination. Because it's a one way synchronization I need.
My requirement:
In the source environment someone is creating a new entry into a certain table --> the corresponding table in the live database should be synchronized immediately.
I had a look at the replication options sql server 2k5 is offering me but I couldn't find anything that seemed to fit. The synchronization we are talking about is obviously a push type communication. But it needs to act immediately upon inserts/updates. Not timer triggered.
I hope this isn't too confusing.
If I left out some important information please let me know and I'll gladly add that.
tia
October 22, 2009 at 6:58 am
Transactional replication is your answer here. Non update transactional replication. The publisher once it gets the change will send the changes to your subscriber. Depending on your DB activity and how many articles are in your publication there might be a latency of 1 to 2 sec.
Read up on Transactional replication in BOL. If you have more doubts please feel free to ask.
-Roy
October 22, 2009 at 10:34 am
Thank you for pointing me into the right direction.
On a brief look the day before I couldn't select transactional replication so I went for merging (which is not what I'm looking for). Now that I know where to start reading I'll happily do just that 🙂
October 22, 2009 at 12:44 pm
Once you have done your basic research to see if that will work, you are free to come back and ask questions if you have any doubts..:-)
-Roy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply