This walkthrough demonstrates how to move data from an on-premises Microsoft SQL Server
data store to SQL Azure
. We will use the Generate Script Wizard, GSW, in SQL Server Management Studio to export the schema. Then we will package our data in a SQL Server Integration Services package and move the data to SQL Azure using the SQL Server Business Intelligence Development Studio. Finally, we will verify the data has been migrated by querying data from our newly created tables in SQL Azure from SQL Server Management Studio.
NOTE: Please run the included CreateTimeAndExpenseTrackDB.sql script against an empty SQL Server database to reset or begin the demo. Along the way you will migrate that schema and data to SQL Azure as you follow the video. Included in the download is another SQL script, CreateCloudTimeAndExpenseTrackDB.sql, which will create an empty SQL Azure database instance with no data in SQL Azure.
- SQL Server Management Studio with SQL Server 2008 R2
- SQL Server Integration Services
- SQL Server Business Intelligence Development Studio
- A pre-existing SQL Azure account
- Knowledge of T-SQL
- Knowledge of SSIS
- Link to video Walkthrough by Steve Yi