We used Log shipping to transfer the data.
There are a couple of things to learn from the experience. We had a couple of issues:
- Unexpected server restart,
- Failure of restore the tail log backup
- Restore over an already restored database.
- Replication failing constantly reporting "login failed for 'sa'".
I am planning to write what we have done and lessons learned from all the issues for the next few days. Stay tuned!