Database Re-engineering/Schema Generator Tools

views:

answers:

+1 Q:

Database Re-engineering/Schema Generator Tools

Hi,

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.

+4 A:

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.

Raj More 2010-07-13 15:26:53

+1 - I'd describe ER/Studio as the best of a bad lot - it seems to have the best coverage of Oracle features. Also, if by "large database" you mean lots of objects rather than data size, than some of the other tools (I'm looking at you, SQL Developer) simply fall over when asked to reverse-engineer.

dpbradley 2010-07-13 15:34:00

Thank you Raj. I will download the trial version and try to work around with it.

Rachel 2010-07-13 15:43:23

Another upvote for ER/Studio. Worth its weight in gold for its ability to take a logical data model, analyze an actual database, then emit the DDL to update the database to match the logical model. Automated the most tedious and error-prone aspect of rolling out a new release for us. Bonus points for doing it for both Oracle and SQL Server with the same logical data model.

TMN 2010-07-13 16:10:52

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.

DCookie 2010-07-13 15:49:33

How can we generate schema diagrams using SQL Developer ?

Rachel 2010-07-13 15:57:54

There is a separate component in the suite called Data Modeler. They do charge for it now, and it appears to be in the same ballpark price-wise as the other tools. You can download and evaluate it however.

DCookie 2010-07-13 16:04:31

ansaurus

tags:

views:

answers:

Database Re-engineering/Schema Generator Tools

related questions