Azure improvement suggestion

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Azure improvement suggestion

Postby renepape » Mon Jun 06, 2011 2:25 pm

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:

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.
renepape
 
Posts: 5
Joined: Mon Mar 02, 2009 10:47 pm

Postby alice.easey » Wed Jun 08, 2011 11:19 am

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
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Re:

Postby TheRubble » Wed Jan 08, 2014 9:24 am

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?
TheRubble
 
Posts: 1
Joined: Wed Jan 08, 2014 9:23 am

Postby acrawford » Mon Aug 11, 2014 6:32 pm

I too would be interested to know if this has been released as I have this exact problem.
acrawford
 
Posts: 7
Joined: Wed Apr 20, 2011 5:57 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests