Deployment Script SQL Azure problems

Forum for users of SQL Compare schema synchronization utility

Deployment Script SQL Azure problems

Postby Martin87 » Fri Apr 27, 2012 3:18 pm


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?
Posts: 1
Joined: Fri Apr 27, 2012 3:15 pm

Postby chriskelly » Mon Apr 30, 2012 12:06 pm

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 and quote the support ticket reference F0059681 in the subject.
Chris Kelly
Technical Support Engineer
Posts: 368
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests