Red Gate forums :: View topic - Deployment Script SQL Azure problems
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 Script SQL Azure problems

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



Joined: 27 Apr 2012
Posts: 1

PostPosted: Fri Apr 27, 2012 3:18 pm    Post subject: Deployment Script SQL Azure problems Reply with quote

Hello.

I'm having a problem with the deployment script when adjusting existing tables on an Azure SQL database.

The generated script tries to create a new table, drops all existing primary and foreign keys, copies the data, delete the old table and rename the new one. However, Azure SQL does not allow tables without a PK, resulting in the script to fail.

Is there any workaround for this?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Mon Apr 30, 2012 12:06 pm    Post subject: Reply with quote

Would it be possible for you to send me an example script which demonstrates the behaviour that you have seen?

Please can you send the example to support@red-gate.com and quote the support ticket reference F0059681 in the subject.
_________________
Chris Kelly
Technical Support Engineer
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