Wednesday, June 02, 2010
I'm reading: How to efficiently use SQL Azure with SSISTweet this !
Microsoft has been taking high bets in cloud based computing industry with SQL Azure. Unimaginable quantity of data lies on OLTP systems, and even if a fraction of it is moved to the cloud, I cannot imagine the quantity of data migration that would have to be made. In Microsoft parlance, SSIS is definitely one great tool which has got required level of potential and support as of date to move data from SQL Server ( OLTP systems in general ) to SQL Azure.
One important point to keep into consideration, which came to my knowledge from a blog post on SQL Azure Team Blog, is that when reading data from SQL Server and writing data to SQL Azure, SSIS would cast or have to cast data to Unicode. So changing the source and destination fields to Unicode data type would spare SSIS from this effort and speed up the execution.
Those who are interested in learning how to read and write data to SQL Azure using SSIS 2008 R2, can read an article authored by me on the same subject from here.