Comparison Script Question

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
mhowell
Posts: 2
Joined: Fri 16 Dec 2016 21:18

Comparison Script Question

Post by mhowell » Fri 16 Dec 2016 21:29

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?

alexa

Re: Comparison Script Question

Post by alexa » Mon 19 Dec 2016 16:08

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

mhowell
Posts: 2
Joined: Fri 16 Dec 2016 21:18

Re: Comparison Script Question

Post by mhowell » Mon 19 Dec 2016 16:54

Thanks for the reply. I look forward to the update.

Post Reply