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

[UKRoyster]

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

[AbdourahmaneBo]

So have you tried it by creating clusters?


Printer ink replacement is always a difficult job for many people.But HP has made ink replacement easier.Get details about hp ink replacement from the link.

[UKRoyster]

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

[eddie davis]

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

[UKRoyster]

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_Compare/SQL%20Compare_9.5.0.482_x86_r180843.zip
_________________
Thanks,
Roy.

Looking for great hotel deals? Try http://lovehoteldeals.co.uk/