是否可以将MySQL Workbench文件保存为纯XML?

时间:2023-01-14 11:04:18

DB Designer had a lot of bugs but one outstanding feature was that database models were saved in plain XML by default.

DB Designer有很多错误,但一个突出的特性是默认情况下数据库模型以纯XML格式保存。

This allowed a user to diff file versions via SVN or Beyond Compare, easily finding any changes made to the database.

这允许用户通过SVN或Beyond Compare来区分文件版本,轻松找到对数据库所做的任何更改。

Unfortunately, DB Designer's succsssor, MySQL Workbench, stores files in a proprietary MVW file format, which is unreadable.

不幸的是,DB Designer的succsssor,MySQL Workbench,以专有的MVW文件格式存储文件,这是不可读的。

Is it possible to force MySQL Workbench to save as XML?

是否可以强制MySQL Workbench保存为XML?

1 个解决方案

#1


9  

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

不,当前版本(5.2.10 beta)不支持这一点。

However, the file format is not proprietary - its a simple zip archive. It contains a single XML document which is the complete database model. I wrote this SO question a couple of months ago with the same goal as you seem to have. I wanted to be able to do svn diff model.mwb

但是,文件格式不是专有的 - 它是一个简单的zip存档。它包含一个XML文档,它是完整的数据库模型。几个月前我写了这个问题,你的目标与你似乎有的一样。我希望能够做svn diff model.mwb

The answer I got there helped me write a small script which unzipped the file before passing it to the diff tool. It worked decently and if you're interested I can post it somewhere.

我到那里的答案帮助我编写了一个小脚本,在将文件传递给diff工具之前将其解压缩。它运作得体,如果你感兴趣我可以把它贴在某个地方。

I also very recently started a thread on the Workbench forum about this issue. Hopefully someone on the development team can provide some more input on this.

我最近也在Workbench论坛上开始讨论这个问题。希望开发团队中的某个人可以提供更多的信息。

EDIT: it is now being tracked by MySQL Bug #51203 with a target of 6.0.

编辑:它现在由MySQL Bug#51203跟踪,目标为6.0。

#1


9  

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

不,当前版本(5.2.10 beta)不支持这一点。

However, the file format is not proprietary - its a simple zip archive. It contains a single XML document which is the complete database model. I wrote this SO question a couple of months ago with the same goal as you seem to have. I wanted to be able to do svn diff model.mwb

但是,文件格式不是专有的 - 它是一个简单的zip存档。它包含一个XML文档,它是完整的数据库模型。几个月前我写了这个问题,你的目标与你似乎有的一样。我希望能够做svn diff model.mwb

The answer I got there helped me write a small script which unzipped the file before passing it to the diff tool. It worked decently and if you're interested I can post it somewhere.

我到那里的答案帮助我编写了一个小脚本,在将文件传递给diff工具之前将其解压缩。它运作得体,如果你感兴趣我可以把它贴在某个地方。

I also very recently started a thread on the Workbench forum about this issue. Hopefully someone on the development team can provide some more input on this.

我最近也在Workbench论坛上开始讨论这个问题。希望开发团队中的某个人可以提供更多的信息。

EDIT: it is now being tracked by MySQL Bug #51203 with a target of 6.0.

编辑:它现在由MySQL Bug#51203跟踪,目标为6.0。