Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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
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 email@example.com
and quote the support ticket reference F0059681 in the subject.
Technical Support Engineer
- Posts: 330
- Joined: Mon Apr 19, 2010 1:44 pm
- Location: Cambridge, UK
Return to SQL Compare 10
Who is online
Users browsing this forum: grinnell and 0 guests