| Author |
Message |
Martin87
Joined: 27 Apr 2012
Posts: 1
|
 Posted: Fri Apr 27, 2012 3:18 pm Post subject: 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? |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Mon Apr 30, 2012 12:06 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
