Deployment to SQL Azure....index errors...
UKRoyster
Posts: 9
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
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
Comments
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
Roy.
Looking for great hotel deals? Try http://lovehoteldeals.co.uk/
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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
Roy.
Looking for great hotel deals? Try http://lovehoteldeals.co.uk/