CODEWITHSUNDEEP
database-design
Dean
Dean

Reputation: 5946

How best can I extract a logical model from a physical DB model

We have made substantial changes to our physical DB, now as it is the end of the project I would like to abstract a logical model from this, to allow me to generate schemas for both Oracle and SQL Server.

Can anyone guide me as to the best way to achieve this. I was hoping TOAD data modeller would help but I can't seem to see any options to do what I require?

Upvotes: 0

Views: 782

Answers (2)

Walter Mitty
Walter Mitty

Reputation: 18940

If your schema consists of 50 tables or fewer, manual methods should work OK. It's tedious and error prone, but if you're careful you should get it right.

The cadillac of schema reverse engineering tools is Data Architect from Sybase. It's pricey, but it's good.

Upvotes: 0

Gilbert Le Blanc
Gilbert Le Blanc

Reputation: 51557

If you're looking to normalize your physical database, this Wikipedia article on database normalization can help.

As far as which tool should you use, a lot of companies use the ErWin data modeler. I use the tools that come with the MySQL community server to do my data modeling, although you would have to manually create the SQL to build Oracle and SQL Server schema.

Upvotes: 1

Related Questions