Deployment Script SQL Azure problems
Martin87
Posts: 2
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?
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?
Comments
Please can you send the example to support@red-gate.com and quote the support ticket reference F0059681 in the subject.