-
Book Overview & Buying
-
Table Of Contents
Microsoft SQL Azure Enterprise Application Development
By :
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 the SQL Azure's Bluesky database.
1. Login into SQL Azure's Bluesky database and create a table called AzureShippers using the following statement:
CREATE TABLE [dbo].[AzureShippers]( [ShipperID] [int] IDENTITY(1,1) NOT NULL, [CompanyName] [nvarchar](40) NOT NULL, [Phone] [nvarchar](24) NULL, CONSTRAINT [PK_Shippers] PRIMARY KEY CLUSTERED ( [ShipperID...
Change the font size
Change margin width
Change background colour