从任何sql语句生成数据库图
我正在使用 DBArtisan 8.5.5,它能够使用“构建查询”生成数据库图表,它有一个很好的功能,可以自动连接,检测图表中新添加的表上的潜在关系。因此该图会生成 SQL 语句,因为它毕竟是一个查询生成器。
是否可以在 DBArtisan 中提供 SQL 语句并生成数据库图?换句话说,相反(给它 SQL 来生成图表,而不是使用图表来生成 SQL)?
如果没有这样的功能,Sybase DB 是否有产品可以提供上述功能?
I'm using DBArtisan 8.5.5 and it has the ability to generate Database Diagrams using Build Query, it has a nice feature that lets it autojoin, detecting potential relationships on newly added tables to the diagram. So the diagram results into a SQL statement since its a Query Builder after all.
Is it possible to provide an SQL statement in DBArtisan and generate the Database Diagram? In other words, the reverse (give it the SQL to generate the diagram, instead of using diagrams to generate SQL)?
If no such feature, is there a product out there for Sybase DB that will provide said feature?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
DbVis 是一个可行的选择,开源且功能强大 - 它有大量的 除了您需要的功能之外的额外功能。
如果您愿意付费,Aqua Data Studio 是一个非常完整且直观的数据库 IDE。
作为中间解决方案,处置不断更新的开源版本 DBeaver 开源 IDE,以及企业版。这两者也都提供了您所需要的功能,目前的主要区别是 Enterprise 中提供的界面、SSH 算法支持和 SQL 调试框架。您可以自己更深入地了解一下,将开源功能与企业版。
DbVis is an actionable choice, being open source and powerful - it's got a good amount of extra features aside from the one you need.
If you're willing to pay, Aqua Data Studio is a very complete and intuitive database IDE.
As a middle ground solution, disposing of both a - constantly updated - open source edition, the DBeaver Open Source IDE, and an Enterprise Edition. Both of these also offer what you need, the main differences as of now being interface, SSH algorithm support and SQL debugging framework offered in Enterprise. You can take a deeper look yourself, comparing the Open Source features with the Enterprise ones.