Moving Data with SQL Azure and SSIS

I did a presentation on moving data to and from SQL Azure for SQLSaturday #49 in Orlando. In it, I reviewed a few of the options available for getting data into and out SQL Azure, including SSIS, BCP, and the Sync Framework. I neglected to load the slides up to the SQLSaturday site, though, so I’m making them available here.

One item to note – in the presentation, I said that the SQL Azure Data Sync tool only supported syncing SQL Azure databases – no on-premise SQL Server. That was correct at the time, but Microsoft has now announced that CTP 2 for Data Sync will support on-premise SQL Servers, meaning it’s a much more viable option for moving data.

The presentation is available here.

Leave a Reply