Video: TechEd 2010 - Migrating Applications to Microsoft SQL Azure
[This article was contributed by the SQL Azure team.]
Are you looking to migrate your on-premise applications and database from MySql or other RDBMs to SQL Azure? Or are you simply focused on the easiest ways to get your SQL Server database up to SQL Azure? Then, this video is for you. Cihan Biyikoglu covers two fundamental areas in this session: application data access tier and the database schema+data. In Part 1, he dives into application data-access tier, covering common migration issues as well as best practices that will help make your data-access tier more resilient in the cloud and on SQL Azure. In Part 2, the focus is on database migration. He goes through migrating schema and data, taking a look at tools and techniques for efficient transfer of schema through Management Studio and Data-Tier Application (DAC). Then, we discover efficient ways of moving small and large data into SQL Azure through tools like SSIS and BCP. He closes the video with a glimpse into what is in store in future for easing migration of applications into SQL Azure.
Summary
Do you have questions, concerns, comments about the information discussed in the video? Post them below and we will try to address them.