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,

Thanks
Roy
UKRoyster
 
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.
AbdourahmaneBo
 
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)

Regards
Roy
UKRoyster
 
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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
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 10.2.6.114...

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

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

ftp://support.red-gate.com/patches/SQL_ ... 180843.zip
Thanks,
Roy.

Looking for great hotel deals? Try http://lovehoteldeals.co.uk/
UKRoyster
 
Posts: 6
Joined: Fri Jan 25, 2013 9:24 am


Return to SQL Compare 10

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests