(edit: no, but they might look at it in the future)įinal edit: I used the Navicat forums and the team were very helpful, but fundamentally Navicat is Windows software and the 64-bit purists behind Centos will never support WINE. Merge the schema SQL files instead)Īlso, bonus question: can we make multiple edits using Navicat other than repeated use of the GUI? If I want to change (say) a bunch of columns from VARCHAR(255) to CHAR(20) I'd normally script that in SQL but Navicat models don't do reverse engineering, only 'delete the table from the model then re-import it' so there doesn't seem to be a non-tedious way to do that.

is there a way to merge a model file if more than one person has changed it? Workbench can't do this but I'd really like the feature.(edit: yes, but the explanation of how to do so is lengthy) Can I relocate them or or symlinks work? I'd rather keep all the DB-related code in one repo, rather than having a special Navicat repo. model and query files are buried deep in the WINE tree.You can manually refresh one file at a time by right clicking) Is there a smart way to do that? (edit: no. when adding new query files Navicat only seems to rescan the folder when I add a new query.How do I get Navicat to work with git (or any other source code control)? Workbench is sufficiently primitive that file changes either get picked up automatically or completely ignored (almost always a dialog 'file on disk has changed, reload?')

Navicat will sort of run with a bit of hacking, but critical features rely on MS-Windows/WINE)

I'm working through the issues of getting Navicat to run on Centos under WINE but assume I will succeed (edit: this failed. I'm looking at switching from MySQL Workbench to Navicat because we're using MariaDB and the incompatibilities are starting to annoy me.

Mariadb navicat