Deployment Script SQL Azure problems

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

Deployment Script SQL Azure problems

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

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?
Martin87
 
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 support@red-gate.com and quote the support ticket reference F0059681 in the subject.
Chris Kelly
Technical Support Engineer
chriskelly
 
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