SQL Import and Export Wizard to SQL Azure DB failing

Question

I'm trying to move data and schema from a hosted SQL Server 2008 instance to a SQL Azure DB and I'm using the SQL Import and Export Wizard in SQL Management Studio.

It almost works, but I get an error:

Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.

This makes no sense, as I have clustered indexes on all my tables. I did see this Q&A on SO but if I switched to .Net Framework Data Provider for SqlServer I get a different error:

Cannot get the supported data types from the, which is the very problem that A is supposed to solve.

What is the definition of the table that is failing?

billinkc
– billinkc

2012-10-22 00:27:06 +00:00
Commented Oct 22, 2012 at 0:27 — billinkc
– billinkc, Commented Oct 22, 2012 at 0:27

Community · Accepted Answer · 2017-05-23 12:04:41Z

2

I suggest using some other tool such as SqlAzureMW (http://sqlazuremw.codeplex.com/) or RedGate's tools because the Import and Export wizard in Sql Management Studio is pretty much useless :-(

Also, take a look at some of the advices here:

How to copy sql azure schema to another sql azure database

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Oct 22, 2012 at 8:32

Ivan Klaric

4231 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Import and Export Wizard to SQL Azure DB failing

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related