June 27, 2011 at 8:08 am
Hi,
My boss asked how can we have one database in one place and the same database in other place people are making changes to this two databases, at the end of the day the two databases should be identical in terms od data.
There is No internet or link (cable) between this two places.
What would you do?
P.S - I can send a person every day do go and pick files generated through this databases so that they import it...
How wuold you do it?
Thank you
June 27, 2011 at 8:29 am
I think we need more info...
do these DB's need to be in sync all the time?
can they be reconsiled at the end of the day?
How large of a DB is this (in gigs)?
just to be clear, there is no internet connection on either db server?
June 27, 2011 at 8:32 am
There is no internet.
"can they be reconsiled at the end of the day" , Yes they can.
500 MB of size
June 27, 2011 at 8:34 am
if the can be reconsiled at the end of the day..then you could compress the bak file and restore on the other server at the end of the day.
this could be done automatically via scripts and possibly batch files.
June 27, 2011 at 8:43 am
krypto69 (6/27/2011)
if the can be reconsiled at the end of the day..then you could compress the bak file and restore on the other server at the end of the day.this could be done automatically via scripts and possibly batch files.
Not if data changes are being made in both locations.
You might be able to do something with Merge Replication. I'm used to doing that with a connection established, but it might be possible by moving files around manually.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 27, 2011 at 8:46 am
Yes, they are made in both locations.
June 27, 2011 at 8:47 am
In that case i think i will do an app in .NET taht exports XML between the two databases...
June 27, 2011 at 8:51 am
Automate red-gate's sql diff maybe?? Is it even possible to script that out?
June 27, 2011 at 9:06 am
the problem you are going to have , no matter which method you choose, is that you will need a method of working out which change 'wins' when it comes to the same row of data being changed in both locations.
June 27, 2011 at 9:08 am
steveb. (6/27/2011)
the problem you are going to have , no matter which method you choose, is that you will need a method of working out which change 'wins' when it comes to the same row of data being changed in both locations.
and when to sync..
can there be down time, aka maintenace mode..where the servers are unavailable?
June 27, 2011 at 9:09 am
yes. that is correct.
But i think that even if i had replication the same thing would happen, correct?
June 27, 2011 at 9:11 am
can there be down time, aka maintenace mode..where the servers are unavailable?
yes, if for a small amout of time
June 27, 2011 at 9:13 am
Merge replication allows you to setup the conflict rules to handle this situation.
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply