Saturday, 15 January 2011

open source - Is it possible to save MySQL Workbench files as plain XML? -


There was a lot of mess of DB designer but an outstanding feature was that database models were saved in plain XML by default .

This allows the user to compare different file versions through SEVN , easily searching any changes made to the database.

Unfortunately, the Db designer's succsssor, MySQL workspace, stores files in a proprietary MVW file format , which is unreadable.

Is it possible to save MySQL workspace as XML?

No, the current version (5.2.10 beta) does not support it.

However, the file format is not owned - it has a simple ZIP archive, it has a single XML document that is the complete database model. I wrote a few months ago with the same goal as you think. I wanted to be able to do svn diff model.mwb

there, I got help writing a small script that unzipped the file before going to the diff tool . It worked fine and if you are interested then I can post it anywhere.

I too started about this issue recently. Hopefully anyone on the development team can provide some more input on this.

EDIT: Now it is being tracked with the goal of 6.0.


No comments:

Post a Comment