Deployment to SQL Azure....index errors...

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Deployment to SQL Azure....index errors...

Postby UKRoyster » Fri Jan 25, 2013 12:33 pm

Hi there,

I have a local sql database thati am comparing to the SQL Azure. Script is generated but when i run it in Azure i get the following issue...

Msg 40054, Level 16, State 2, Line 1
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.

Is there an option to say that it must conform to SQL Azure?

Require urgent advice if possible,

Posts: 6
Joined: Fri Jan 25, 2013 9:24 am

Postby AbdourahmaneBo » Sun Jan 27, 2013 9:57 am

So have you tried it by creating clusters?
Last edited by AbdourahmaneBo on Wed May 29, 2013 1:34 pm, edited 1 time in total.
Posts: 1
Joined: Sun Jan 27, 2013 9:52 am
Location: United States

Postby UKRoyster » Mon Jan 28, 2013 10:12 am

Yes. I am using the EF (4.1) with model-first approach. the EMDX sql file creates all the clustered indexes as required.

The Azure DB that i am trying to upgrade is failing on the table that has a clustered index.

Problem is: Azure requires a clustered index which means i can't drop it (as its required)

Posts: 6
Joined: Fri Jan 25, 2013 9:24 am

Postby eddie davis » Mon Jan 28, 2013 12:34 pm

Hi UKRoyster

I believe that we already have a support call raised with you, call reference F0068883.

I have just updated the call and sent an e-mail to you.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby UKRoyster » Mon Jan 28, 2013 12:48 pm

For anyone else that has the clustered index issue while upgraded to Azure using SQL Compare

Red-gate have reported bug with reference number is SC-6147.

To get around it while bug bieng fixed, download SQL Compare V9.5 ...

Looking for great hotel deals? Try
Posts: 6
Joined: Fri Jan 25, 2013 9:24 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest