We will be using SqlBulkCopy; a class supported from .NET Framework 2.0, to copy data from a table in SQL Express to a table with the same schema in SQL Azure.
The details of SqlBulkCopy class displayed in Visual Studio 2010 RCs Object Browser is shown in the following screenshot:
The data transfer takes place from one database object on one server, to a database object with a similar schema on another server. We will transfer the data from the
Shippers table in
Northwind on SQL Server 2008 Express, to a table in the
Bluesky database on SQL Azure.
In the next step, we will create a table in ...