The script generated by the deployment wizard is not correct
Izaskun Usabiaga
Posts: 2
Hello,
Using SQLCompare 11.1.3.30.
We have a database that is in constant modifications and we generate different versions for this database. In a case that a table has been modified (among the modification a column is renamed), we generated the script for the update with the deployment wizard and the sequence for the rename and the use of the renamed column, was not correct. In other words, the script was using the renamed column name, before being renamed.
In case you need an example we can provide you the scripts to reproduce the error.
Using SQLCompare 11.1.3.30.
We have a database that is in constant modifications and we generate different versions for this database. In a case that a table has been modified (among the modification a column is renamed), we generated the script for the update with the deployment wizard and the sequence for the rename and the use of the renamed column, was not correct. In other words, the script was using the renamed column name, before being renamed.
In case you need an example we can provide you the scripts to reproduce the error.
Comments
I have logged a support ticket for you and you will receive an email shortly.
Can you please reply my email with an example?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com