All geek questions in one place

Database modeling software with non-binary file format?

Do you know database modeling software whose file format can be safely tracked using VCS without creating conflicts? (i.e. not a binary file format.) It would be great if the software also worked on Linux and MacOS.

It would be even better if the file format could be easily deleted.

Edit:

I am currently using MySQL Workbench and am happy with it, however its binary file format creates conflicts in VCS, and using it is a pain because of this.

+4
source share
5 answers

The only available tool that I know is WWW SQL Designer .

+1
source

I think your question has been answered: MySQL Version Control - Subversion

+2
source

I am using microOLAP to design my MySQL database. This is a Windows application, unfortunately (I also have Linux MySQL + mysql), but it works like a charm. It generates XML from a database schema, so it can be safely imported into any VCS. Otherwise, you can try Dia on Linux. It is not as advanced as microOLAP, but has limited design capabilities for ER-diagrams.

+1
source

There is a predecessor to Workbench, DBDesigner , which saves XML files and has versions for Windows and Linux.

Alternatively, you can use the pre-commit and post-update bindings to convert the Workbench model files before committing and recreate them after the update and put non-binary data in version control. However, you should still be careful when merging.

  • Pre-commit: unzip the model file, save the XML and SQLite dump
  • Post-update: recreate the SQLite database and create the model file.
+1
source

You can try "Workbench MySQL"

0
source

Source: https://habr.com/ru/post/1336518/

More articles:


All Articles