Using Red Gate for Migration
We are using red gate for migration as guys who are hosting our servers currently backup databases using red gate. So we are buying red gate so that we can restore these databases on our environment.
However I had few queries,
1) Can we restore sql server 2005 red gate backup on sql serv 2008 R2 release ?
2) We want to establish log shipping (not ideally) to minimize downtime on cutover date. Since there is no connectivity from source to destination servers, we are planning to ask them to backup the database to an FTP site and then we would pick it up and restore the database. After this they would take backups of transaction logs and keep them on FTP site and we would use scheduled restore option in red gate to restore them to our site. Does it sound like correct approach?