In this training demo on SQL Azure, we will demonstrate how to move data from local on premise SQL Server 2008 to SQL Azure in the cloud environment. Before you get started, you do need to have the destination table in Azure SQL database first. Using transact SQL code we create the PRODUCTS table and also create clustered index on it. Next we use Business Intelligence Development Studio (BIDS) to create a SQL Server Integration Services (SSIS) project…
You can watch the sample video on this training at this location: (Right click – Save As)
Complete information on SQL Azure Cloud database can be found at Sql Azure Training page.