October 22, 2006 at 11:50 am
Good afternoon all. I have a potential client that has multiple locations. They would like to 'replicate' transactions from each location to the main office on a regular schedule, say every 30 minutes. They do not want to use replication as the internet connection between the offices is poor. Their idea is to use the Transaction logs, upload them to the head office and perhaps use a DTS to import the text files. I am not thinking that this is a good idea at all!
Any feedback here?
<hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh
October 23, 2006 at 8:59 am
Hi,
What do you mean by 'poor internet connection' ?
So the idea is to take the transaction logs from each remote office and load them into the Head Office DB...Hmmmm...that sounds like a nightmare waiting to happen to me.
How will the transaction logs at each remote office know about each others records?
Are they all entering data into the same tables? Do these tables have identites?
Is it possible that 2 remote offices will generate a record with the same ID for a particular table ? How can this be resolved at the head office?
These are a few questions that came to mind while reading your post.
The reason why I asked about the link is that it sounds like merge replication could be an answer here. This type of replication tolerates link downtime and can manage such problems as Identites over a number of sites pretty well.
I can't imagine a solution that doesn't use a replication approach otherwise you are effectively trying to combine many standalone DBs into one. I suppose it is not impossible but there would be a large amount of administration.
HTH
Graeme
October 23, 2006 at 11:14 am
More over I don't think u can use Xaction log backup from SQL Server and apply it on another SQL Server(Unless u are using Log Shipping). Xaction log restore will check if you are applying in particular order and WILL NOT WORK if you are doing from multiple location.
I think your client is confused with Log Shipping (Which is a different entity) and looks like u need MERGE replication.
Thanks
Sreejith
October 23, 2006 at 11:46 am
there are tools you can use to read logs and to create the statements to reverse the transactions. I would presume they can create the transaction statement forward, as well. If the data is partitioned at the remote sites, say, by zip code, and you can guarantee that there are no collisions, this could probably be designed to work; but I agree, on the surface, it looks like a disacter waiting to happen.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
October 23, 2006 at 4:27 pm
Also, transaction logs are not text files and can't be imported by DTS.
Greg
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply