Hi,
I need to maintain the same data across two servers, and I wanted to know what is the best method that I can use to do that.
There is Server A (SQL server 2000) on which the changes are made. And there are few tables which have "text" column, which needs to be replicated to server B (Server server 2000). The changes made on server A should be more or less immedietely replicated (5-10 mins lag is acceptable) to server B.
There are several options I could think of;
(a) Create trigger on server A, which then implements the same changes on server B
(b) Transactional replication (But does this allow text field to be replicated?)
(b) Logshipping
I wanted to know, if there are any other options available.
And If you are suggesting one of the options mentioned above, could you please give me the reason as to why that is the best option.
Thanks very much
GYKTransactional replication would appear the best method for what you are
trying to do. It is easy to set up and will allow text data to be
replicated from Server A to Server B.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment