What are the challenges you face when working across database platforms? Take the survey

Deployment Script SQL Azure problems

Martin87Martin87 Posts: 2
edited April 30, 2012 7:06AM in SQL Compare Previous Versions

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?


Sign In or Register to comment.