We have a few SQL Migrations were doing over here where we are backing up from several SQL Servers and moving them to a shared SQL Server (About 600 databases in from 6 servers). When using SQLBackupAndFTP to create and place the backups into a directory I don’t see an option to restore them to another SQL Server (Looks like it will only restore to the original). We have 1 SQL Server to migrate a week for the next 6 weeks.
Dear Kory,
We are working on built-in advanced restore feature that would answer your question, but it is about a month away. In the mean time to restore on another server you can use our One Click SQL Restore or just the standard RESTORE command. More details