Loading
The fastest way to move data between 2 databases on separate instances is by leveraging a utility called SmartBulkCopy. This little app moves data between SQL Databases 1.5-2x faster than all the tools out there! And its freely available: download your copy from: https://github.com/yorek/smartbulkcopy