I have a database in a server in Africa, and need a daily sync\restore to a server in Europe.
My first idea was to sync the data between the 2 databases, but the database has more than 1000 tables, and is not well built, so the software I've tested didn't work great.
For what I've read the best option is to backup the database in one server and restore it to the remote server.
Is this the best solution?
Is Redgate Backup Pro the best tool for the task?
I've been playing with it and it seems to have everything I need: backup\restore scheduling, compression, etc.
Need some advice on this. Thanks in advance :)