In the previous post we had examined on getting access to SQL Azure, creating your first database, accessing it with SQL Server Management Studio and then migrating the Northwind database schema to SQL Azure using the SQL Azure Migration Wizard Beta. As explained earlier, the SQL Azure Migration Wizard migrates the schema of your database after tuning it for working with SQL Azure. However, we would still need to migrate the Data to our SQL Azure Server. At the moment, the step I took was to open the instnwnd.sql script in SQL Server Management Studio (SSMO) and copy the Insert statements alone to execute. Note that, you cannot run all the scripts directly onto the SQL Azure portal like I explained earlier due to the limitations / formats supported...(read more) ...
Go to the complete details ...