November 3, 2009 at 9:34 am
I am stuck with a problem. I have similar databases on two boxes which have no connectivity with each other. Each database may be connected by respective users & data can be inserted/updated daily. What I need to achieve is, at the end of business hours the transactions done in each database should be reflected onto the other one also. I mean at the end of the day both should have same data. Is there a way this can be achieved offline?
November 9, 2009 at 5:26 am
Hi ,
You may synchronize the the two databases using any synchronizing tools.
I use the xSQL compare tool for data synchronization between two similar database.
Dunno any query as such for doing that.
November 10, 2009 at 2:33 pm
What types of transactions are occurring on the 2 databases ? Updates ?
What if PersonA updates Database_A.TableA.Cost = $25.00
while PersonB updates Database_B.TableA.Cost = $40.00
What should happen when you synchronize ?
If the servers can "talk" to each other, I think Merge Replication would do what you want.
(Or am I misunderstanding your situation ?)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply