Question

Data mirroring

Mirroring, Database mirroring

Hi Guys,
Can any one tell me how can i keep two databases in sync?
My problem :
I have two boxes DEV and PROD and have a data library in each box.
What i want is to keep my DEV data library in sync with the PROD real time.
If real time is too difficult to achieve ......how about end of day?
ideas???

thanks

Hi,

I am not very sure about waht typw of files exists in the libraries you are reffering to. But if these are the system libraries which are small size binary files, then you can implement rsync between the two servers. All the changes will be copied to the DEV server. You can automate the task by scheduling it through cron.

Thanks

*****************************************************************
Not sure what OS or applications you are using, but this might help:
To save buying another backup liscense for our network, I mapped a folder on a server that is on the backup string as a drive on our time clock server. I wrote a script that copies the entire data/program folder of our time clock server to that drive (The folder if small, about 150 Meg). This script fires off about 20 minutes before the main backup starts. I had to restore from the backup once, and it worked fine. The script was added to the scheduled task list in the Time Clock server's Control Panel. Perhaps using the mapped drive/script idea could work for you.
Good Luck

From OpenSystemsStorageGuy: this can be done natively by some databases, and can be done by certain types of centralized storage. Assuming you're trying to do it with internal storage on both servers with a database that doesn't support real time replication, you can either script the replication yourself, or you can buy some software that will do it for you. The obvious one would be doubletake.