Description:
Hello,
I’m using MySQL Workbench SE since two months ago, and I would like contribute with one possible new feature.
All the tables of my database model use MyISAM engine for historical reasons. Now, I’ve created the database model in MySQL Workbench and I’ve defined foreign keys although MyISAM doesn’t support. For me is very interesting create the foreign keys because is very useful for the maintenance and documentation of the database.
The problem is when I execute the “Generate catalog diff report” returns me a lot of differences because in my database doesn’t exist the foreign keys (for MyISAM engine limitations). The same problem I have when I execute the “Synchronization” database to model. In this case all the foreign keys defined in the model are erased. It could be a very useful feature add one button or check box to ignore the foreign keys in the “Synchronize” and “Generate catalog diff report” functionalities of MySQL Workbench. With this button we could maintain our database using all the functionalities of MySQL Workbench because ignores the foreign keys defined.
I think this problem can suffer more users because a lot of MySQL databases uses MyISAM engine in his tables.
Thanks in advance for your attention and I hope this feature you like ;)
Best regards,
How to repeat:
The problem is when I execute the “Generate catalog diff report” returns me a lot of differences because in my database doesn’t exist the foreign keys (for MyISAM engine limitations). The same problem I have when I execute the “Synchronization” database to model. In this case all the foreign keys defined in the model are erased. It could be a very useful feature add one button or check box to ignore the foreign keys in the “Synchronize” and “Generate catalog diff report” functionalities of MySQL Workbench. With this button we could maintain our database using all the functionalities of MySQL Workbench because ignores the foreign keys defined.
