·Hi There, for the sql server to sql azure case, You can use SSIS. The data pump task may spill things to disk but data stays in memory for the
most part and there isn't a need to first export, save then import.
For the SQL Azure to SQL Azure case, you could write an quick app using SqlBulkCopy in .Net. This would move the data
within the datacenter and would be more economical than moving the data through bcp or SSIS through an external proxy.
SQLBulkCopy works very well ... thanks for the good idea! Your thoughts on pros/cons of where to host the app? For example, would it make any performance difference hosting the app at the same data center as the source or target database (assuming
they are different)?
Edited byMike McIverSaturday, May 12, 2012 4:20 PMclarification
Edited byMike McIverSaturday, May 12, 2012 4:21 PMclarification