Red Gate forums :: View topic - Deployment to SQL Azure....index errors...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

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

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
UKRoyster



Joined: 25 Jan 2013
Posts: 6

PostPosted: Fri Jan 25, 2013 12:33 pm    Post subject: Deployment to SQL Azure....index errors... Reply with quote

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
Back to top
View user's profile Send private message
AbdourahmaneBo



Joined: 27 Jan 2013
Posts: 1
Location: United States

PostPosted: Sun Jan 27, 2013 9:57 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
UKRoyster



Joined: 25 Jan 2013
Posts: 6

PostPosted: Mon Jan 28, 2013 10:12 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Mon Jan 28, 2013 12:34 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
UKRoyster



Joined: 25 Jan 2013
Posts: 6

PostPosted: Mon Jan 28, 2013 12:48 pm    Post subject: Reply with quote

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/
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group