I have a question about the script that is generated via the comparison.
Is there a way to make the script generation drop fk relationships in a table before it tries to alter the table that the fk is pointing to?
I have two tables
Laser
Cats
My issue is that I have changed a column in Laser bigint to int. I dropped the fk in Cats before I did this and then updated Laser and then updated Cats and reestablished my fk. I was able to run the comparison tool and update the project fine. Now I want to take my changes that I applied to the project and apply them to another version of the database so that it is up to date. I run the comparison and then generate the script and run it. The script fails because it is trying to alter table Laser before it has drop the fk that Cats has to Laser.
Am I generation my script wrong?
Comparison Script Question
Re: Comparison Script Question
We will fix this issue in one of the next product builds and will notify you once it's available for downloading.
Re: Comparison Script Question
Thanks for the reply. I look forward to the update.