How can we help you today? How can we help you today?

Deployment Script SQL Azure problems

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
0

Comments

1 comment

Sort by
  • chriskelly
    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.
    chriskelly
    0

Add comment

Please sign in to leave a comment.