This article show you how to connect to Windows Azure SQL Database using SQL Server Import and Export Wizard. Once you understand how to connect to SQL Database, you can migrate data between SQL Database and other data sources/destinations.
For more information on using the wizard, see Importing and Exporting Data by Using the SQL Server Import and Export Wizard .
SQL Server Import and Export Wizard is capable of copying schema and data, but not other database objects like indexes, constraints and stored procedures. Because SQL Database only supports tables with a clustered index, migrating both schema and data at
the same time will fail. The wizard is better used for migrating data only. For migrating schema and other SQL Database data migration options, see Overview of Options for Migrating Data and Schema to Windows Azure SQL Database.
When you migrating data from SQL Server to SQL Database, it is also important to note that SQL Database does not support all SQL Server data types and features. This can complicate the data migration process. For more information, see Guidelines
and Limitations (Windows Azure SQL Database) and Comparing SQL Server
with Windows Azure SQL Database.
You must complete the following steps:
The following procedures show you a custom solution for migrating both schema and data from SQL Server to SQL Database. As stated in the beginning of the article, the wizard is better used for migrating data only. The main goal of these procedures is to
show you how to connect to SQL Database from the wizard.
To migrate schema from SQL Server to SQL Database
For more information on Encrypt and TrustServerCertifiate, see Security Guidelines and Limitations (Windows Azure SQL Database).
- Copying to [TableName] (Error)
Error 0xc020844b: Data Flow Task 1: An exception has occurred during data insertion, the message returned from the provider is: Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
(SQL Server Import and Export Wizard)
The error message indicates clustered index is required for SQL Database tables.
Note: Do not close the Wizard. You will come back to the wizard after you create clustered index for the table.
To create clustered index for the SQL Database table
create clustered index idxAddressID on person.address(addressid)
After you execute a statement, click the Messsage button to make sure the command is completed successfully.
To migrate data from SQL Server to SQL Database