Database modeling software with non-binary file format?

Question

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

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

Edit:

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

score 2 · Answer 1 · edited May 23 '17 at 12:26

2

I think your question is answered here: MySQL Version Control - Subversion

edited May 23 '17 at 12:26

Community

1
1

answered Jan 31 '11 at 01:25

blueberryfields

45,910
28
89
168

Liquibase looks awesome. Unfortunately it seems that the gui has never gone beyond _technology preview_ and is not even available for download – Arnaud Le Blanc Jan 31 '11 at 09:31

score 1 · Answer 2 · answered Jan 21 '11 at 21:12

1

I use microOLAP for MySQL database design. It's a windows application unfortunately (I'm a Linux+Mac user mysql too), but it works like a charm. It generates XML out of the database schema, so it can safely be imported into any VCS. Otherwise, you can try Dia on Linux as well. It's not as advanced as microOLAP, but it does have limited ER-diagram designing possibilities.

answered Jan 21 '11 at 21:12

Friek

1,533
11
13

Thanks. Unfortunately Dia is not great as a db modeling tool. – Arnaud Le Blanc Jan 28 '11 at 13:18

score 1 · Accepted Answer · edited Jan 31 '11 at 10:33

1

The only avaiable tool I know is WWW SQL Designer.

edited Jan 31 '11 at 10:33

Arnaud Le Blanc

98,321
23
206
194

answered Jan 29 '11 at 18:54

Daniel

27,718
20
89
133

score 1 · Answer 4 · answered Jan 31 '11 at 08:13

1

There is Workbench's predecessor, DBDesigner which saves XML files and has Windows and Linux versions.

Alternatively, you could use pre-commit and post-update hooks to convert your Workbench model files before a commit and recreate them after an update and put the non-binary data into version control. However, you would still have to be careful when merging.

Pre-commit: Unzip the model file, store the XML and a SQLite dump
Post-update: Recreate the SQLite database and generate model file.

answered Jan 31 '11 at 08:13

Arc

11,143
4
52
75

Note that I've experienced some crashes with DBDesigner in the past - as I did with Workbench; however, development stopped when Workbench came out. So, save frequently if you decide to use it. – Arc Jan 31 '11 at 08:20

score 0 · Answer 5 · answered Jan 28 '11 at 08:38

0

You can try the "MySQL Workbench"

answered Jan 28 '11 at 08:38

VeroLom

3,856
9
34
48

This is what I am currently using. The file format is two zipped files: a XML doc and a SQLite db. In the end this is a binary format. – Arnaud Le Blanc Jan 28 '11 at 08:48
2

You can .dump a SQLite schema. But that's an extra manual step. Might be worth the trouble, though. – Mike Sherrill 'Cat Recall' Jan 29 '11 at 23:52

Database modeling software with non-binary file format?

5 Answers5