tomoemon / mwb2sql

convert mwb (MySQL Workbench file format) to sql

mwb2sql

What is this?

mwb2sql is a shell command utility to produce sql file from mwb file (file format of MySQL Workbench).

Usage

on Windows

mwb2sql.bat sample/test.mwb a.sql

on Linux (with GUI)

sh mwb2sql.sh sample/test.mwb a.sql

on Linux (without GUI)

Xvfb :1 &
DISPLAY=:1 sh mwb2sql.sh sample/test.mwb a.sql

Known Issues

• MySQL Workbench application always displays a window even if a script option is specified.
• generateSQLCreateStatements function seems to have a option that control the behavior of dumping sql, but the option has no effect. (I can't find the way to enable the option).
  This has been reported to the MySQL team at: https://bugs.mysql.com/bug.php?id=84390 - if interested in a fix please create a bugs.mysql.com account and click the 'Affects me' button.

mwb2sql's Issues

SQL Object Filter

It would be nice if one could filter objects (Tables, Views, Routines or Triggers) as in MySQL Workbench GUI "Export/Forward Engineer SQL CREATE Script…".

Omitting schema in generated script

Problem with 3rd parameter of function generateSQLCreateStatements function seems to be solved. Use parameter 'OmitSchemas':1

--run-python "import os;import grt;from grt.modules import DbMySQLFE as fe;c = grt.root.wb.doc.physicalModels[0].catalog;fe.generateSQLCreateStatements(c, c.version, {'OmitSchemas':1});fe.createScriptForCatalogObjects(os.getenv('OUTPUT'), c, {'OmitSchemas':1})" ^