Activity overview
Latest activity by UKRoyster
Bug is fixed. Thank you Andy. / comments
Bug is fixed. Thank you Andy.
Constraints are dropped but not re-added.
SQL Compare 10.3.8
I am struggling with the script generation. After comparing two databases, I can see that the generated script drops all constraints (Foreign keys), but no where in the script ar...
For anyone else that has the clustered index issue while upgraded to Azure using SQL Compare 10.2.6.114...
Red-gate have reported bug with reference number is SC-6147.
To get around it while bug bieng fixed, download SQL Compare V9.5 ftp://support.red-gate.com/patches/SQL_ ... 180843.zip / comments
For anyone else that has the clustered index issue while upgraded to Azure using SQL Compare 10.2.6.114...
Red-gate have reported bug with reference number is SC-6147.
To get around it while bug bi...
Yes. I am using the EF (4.1) with model-first approach. the EMDX sql file creates all the clustered indexes as required.
The Azure DB that i am trying to upgrade is failing on the table that has a clustered index.
Problem is: Azure requires a clustered index which means i can't drop it (as its required)
Regards
Roy / comments
Yes. I am using the EF (4.1) with model-first approach. the EMDX sql file creates all the clustered indexes as required.
The Azure DB that i am trying to upgrade is failing on the table that has a ...
Deployment to SQL Azure....index errors...
Hi there,
I have a local sql database thati am comparing to the SQL Azure. Script is generated but when i run it in Azure i get the following issue...
Msg 40054, Level 16, State 2, Line 1
Tables wi...
Multiple databases + system generated constraint names...
Hi there,
I have multiple Azure databases all with same schema version, however they do have different system-generated constraint names.
1. Do I need to prepare an upgrade script for each database...