I have a SQL Server 2008 database. I'm trying to put it on SQL Azure. I have table schemas already inserted into Azure SQL. I was hoping to use the import / export wizard to migrate my database. However, after selecting the destination in the SQL Server Import and Export Wizard and click "Next", I get an error message:
TITLE: SQL Server Import and Export Wizard
------------------------------
Cannot get the supported data types from the database connection "Provider=SQLNCLI10;Data Source=tcp:[server],1433;User ID=[userID];Auto Translate=false;Initial Catalog=[dbName]".
Unspecified error
The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator. (Microsoft SQL Server Native Client 10.0)
What am I doing wrong?
Thank.
source
share