具有非二进制文件格式的数据库建模软件?
您是否知道一种数据库建模软件,其文件格式可以由 VCS 安全地跟踪,而不会总是产生冲突? (即非二进制文件格式。)如果该软件也能在 Linux 和 MacOS 上运行,那就太好了。
如果可以轻松区分文件格式就更好了。
编辑:
我目前正在使用 MySQL Workbench 并且对它很满意,但是它的二进制文件格式不断在 VCS 中产生冲突,因此使用它很痛苦。
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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
我认为你的问题在这里得到了解答: MySQL 版本控制 - Subversion
I think your question is answered here: MySQL Version Control - Subversion
我知道的唯一可用工具是 WWW SQL Designer。
The only avaiable tool I know is WWW SQL Designer.
我使用 microOLAP 进行 MySQL 数据库设计。不幸的是,它是一个Windows应用程序(我也是Linux+Mac用户mysql),但它的工作方式就像一个魅力。它根据数据库模式生成 XML,因此可以安全地将其导入到任何 VCS 中。
否则,您也可以在 Linux 上尝试 Dia。它不像 microOLAP 那么先进,但它的 ER 图设计可能性确实有限。
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.
Workbench的前身是DBDesigner,它保存XML文件,有Windows和Linux版本。
或者,您可以使用预提交和更新后挂钩在提交之前转换 Workbench 模型文件,并在更新后重新创建它们,并将非二进制数据放入版本控制中。不过,合并时仍需小心。
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.
您可以尝试“MySQL Workbench”
You can try the "MySQL Workbench"