从 Oracle 数据库逆向工程数据库
我想知道是否有任何工具能够从现有的 Oracle 数据库中提取设计。
我有它的读取权限,并且我想要设计。或者简单地将其导出到 *.sql,然后使用任何能够使用表之间的链接创建设计的工具读取它。 类似的东西
(来源:fileguru.com)
非常感谢。
I would like to know if there is any tool able to extract the design from an existing Oracle database.
I have a read access to it and I would like to have the design. Or simply export it to a *.sql and then read it with any tool able to create the design with the links between the tables.
Something like that
(source: fileguru.com)
Thank you very much.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
有许多工具可以从 Oracle 数据库进行逆向工程,但大多数都需要许可证。
Oracle 有自己的数据建模器。此前,甲骨文试图收取过高的许可费,但显然他们的接受者很少,因为现在是免费的。它不是一个伟大的产品,但在逆向工程方面做得不错。
如果您是使用 TOAD 的网站,那么您绝对应该考虑 Quest 的 TOAD 数据建模器 。额外费用与基本 TOAD 费用相比并不算很大。
市场上已经没有多少其他免费工具了,但 SQL Power 提供了 SQL Architect 工具的社区版本,可以进行逆向工程。 查看一下。
There are a number of tools which do reverse engineering from an Oracle database, but most require a license.
Oracle has its own Data Modeller. Previously Oracle tried to charge an exorbitant licence fee but obviously they had few takers because it is now free. It is not a great product but it does a decent job on reverse engineering.
If you are a site which uses TOAD then you should definitely consider Quest's TOAD Data Modeler. The additional cost is not a great stretch from the basic TOAD fee.
There are not many other free tools left on the market but SQL Power offer a community edition of their SQL Architect tool which does reverse engineering. Check it out.
Oracle SQL Data Modeler 回答了我的所有问题。
它有一个逆向工程工具,可以从数据库创建逻辑和物理模型。
Oracle SQL Data Modeler answered to all my questions.
It has a reverse engineering tool that creates the logical and physical model from the database.