Red Gate forums :: View topic - Azure improvement suggestion
Return to www.red-gate.com RSS Feed Available

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

Azure improvement suggestion

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
renepape



Joined: 02 Mar 2009
Posts: 5

PostPosted: Mon Jun 06, 2011 2:25 pm    Post subject: Azure improvement suggestion Reply with quote

Hi
If the name of the primary key has been changed on the local database, then SQL Compare will issue a 'drop constraint' to recreate it using the new name, but that doesn't seem to be allowed in Azure:

Quote:
The following error message was returned from the SQL Server:

[40054] Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
Could not drop constraint. See previous errors.

The following SQL command caused the error:

ALTER TABLE [files].[DataAvailability] DROP CONSTRAINT [PK_DataNotAvailable]


As a minimum, you could include a warning in the warnings list, alternatively do a full table rebuild instead, as you do with major datatype changes (when you see that the target is Azure).
Another idea would be to include a sort of "Quick-options" for Azure targets, so that the user easily could set all the necessary Ignores to make it work.

Thanks for a wonderful product.
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Wed Jun 08, 2011 11:19 am    Post subject: Reply with quote

Thanks for your post.

We've fixed this issue internally and do a full table rebuild instead (if the field modified is part of a primary key).

We're hoping to do a point release soon that includes this fix: no definite timescales yet I'm afraid, but I'll notify you with any developments in this area.

Alice.
Project Manager
SQL Tools
Back to top
View user's profile Send private message
TheRubble



Joined: 08 Jan 2014
Posts: 1

PostPosted: Wed Jan 08, 2014 9:24 am    Post subject: Re: Reply with quote

alice.easey wrote:
Thanks for your post.

We've fixed this issue internally and do a full table rebuild instead (if the field modified is part of a primary key).

We're hoping to do a point release soon that includes this fix: no definite timescales yet I'm afraid, but I'll notify you with any developments in this area.

Alice.
Project Manager
SQL Tools


Has this been released?
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