vendredi 16 janvier 2015

The options to replicate a secondary read-only copy of a big database with limited network connection?

There is a big database on remote server. A read-only replicate is required on a local server. The data can only be transferred via FTP, etc. It's ok to replicate it once a day.


Logshipping is an option. However, it need to kill all the connections when doing restoring. What's the other options (pros/cons)?


Aucun commentaire:

Enregistrer un commentaire