February 5, 2005 at 1:54 pm
As I understand, a periodic log shipping can be configured to ship transactional changes (updates) from primary server to the secondary (destination) server to bring entire db in synch. But I want to synchronize only few tables of the db. Is there anyway to select few tables and filter out records at the primary server BEFORE log shipping it to the secondary server? I am trying to keep the network traffic to its minimum.
Replication (transactional, snapshot, or merge) doesn't meet the requirement of my application for the same reasons: network traffic. Replication, however, allows me to select few tables and filter out records for replication. Is it possible to do the same with log shipping? if so then how?
I will greatly appretiate your help.
February 5, 2005 at 6:28 pm
Log shipping maintains an identical read-only copy of the entire database, it's all or nothing.
I think you would be better off with transactional replication of your selected tables.
You could also come up with your own method to keep the tables updated using triggers or DTS. I don't think this would be any less network traffic.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 7, 2005 at 7:06 am
I'd studied log shipping far and wide and agree with Kathi. As there was said: "it's all or nothing"
February 7, 2005 at 11:36 am
Thanks a lot to Kathi and Vidas.
Now, I will try to do it using trigger and SP on our own.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply