数据库重新设计/模式生成工具
我加入了一个已经开发的项目,它是一个具有非常大的数据库且使用 Java/J2EE 的遗留项目。
我想了解数据库设计和数据库设计架构,是否有可用的工具可以从填充的表生成表示所有约束(如外键等)的模式?
基本上我正在寻找数据库重新设计工具。我的数据库是Oracle 10g。
如有意见,我们将不胜感激。
I have joined a project which has been already developed and its a legacy project with very large database and its in Java/J2EE.
I am trying to understand the Database Design & Architecture and so is there a tool available which can generate schema from the populated table representing all the constraints like foreign keys etc ?
Basically am looking for an Database Re-engineering Tool. My database is Oracle 10g.
Inputs would be highly appreciated.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
我使用 ER/Studio,并且非常喜欢它来完成我的所有数据建模、逆向工程和数据库设计工作。
http://www.embarcadero.com/products/er-studio
我真的应该成为一名 ER/Studio 传播者……但实际上,它是一个很棒的产品。
I use ER/Studio and I absolutely love it for all my data modeling, reverse engineering and database design work.
http://www.embarcadero.com/products/er-studio
I should really become an ER/Studio evangelist.. but really, it is a great product.
没有太多使用它,但 Oracle 有一个包含在 SQL Developer 中的工具: Oracle SQL Developer Data Modeler。 我同意 @Raj 的观点,即 ER Studio 非常好;我还使用过 ERWin。两者都有价格相当昂贵的缺点。有一段时间是免费下载的,但我现在看到他们似乎正在收费。不知道多少钱。
Haven't played much with it, but Oracle has a tool included with SQL Developer: Oracle SQL Developer Data Modeler. I agree with @Raj that ER Studio is very good; I've also used ERWin. Both have the drawback of being quite pricey. For a while there was free downloads, but I see now it appears they're charging for it. Don't know how much.