Reversing already existing database structures

The reverse engineering process will extract the database's entities, attributes, relationships, indexes, triggers, procedures, and other objects depending on the particular database. Not all of those features are supported by all databases. In addition to being able to work with a number of databases, Toad™ Data Modeler is able to use a number of different communication methods:
  • ODBC
  • ADO
  • direct native connections where appropriate.

Reverse engineering - the benefits

  • Toad™ Data Modeler allows you to generate very detailed HTML and RTF documentation. It is a perfect tool for creating documentation of your already existing database structure.
  • You can re-draw the db structure, insert the model into the internal Version Manager or generate new SQL (DDL) scripts.
  • During the reverse engineering process, Toad™ Data Modeler loads various objects of selected databases. Each database has its own specifics and Toad™ Data Modeler respects them as possible.

Supported databases - Toad Data Modeler 5

Database
Native
ODBC
ADO
TCP/IP
DB2 v.10.1 (LUW)
yes
yes
yes
-
DB2 v.9.7 (LUW)
yes
yes
yes
-
DB2 v.9.5 (LUW)
yes
yes
yes
-
DB2 v.9 (LUW)
yes
yes
yes
-
DB2 UDB v.8 (LUW)
yes
yes
yes
-
DB2 z/OS v.10
yes
yes
yes
-
DB2 z/OS v.9
yes
yes
yes
-
Ingres 10.0
-
yes
-
-
Ingres 9.3
-
yes
-
-
Microsoft Access 2007/2010
-
-
yes
-
Microsoft Access 2000-2003
-
-
yes
-
Microsoft SQL Azure
-
-
yes
-
Microsoft SQL 2008
-
-
yes
-
Microsoft SQL 2005
-
-
yes
-
Microsoft SQL 2000
-
-
yes
-
MySQL 5.5
yes
yes
-
-
MySQL 5.1
yes
yes
-
-
MySQL 5.0
yes
yes
-
-
Oracle 12c
yes
-
yes
yes
Oracle 11g R1 & R2
yes
-
yes
yes
Oracle 10g
yes
-
yes
yes
Oracle 9x
yes
-
yes
yes
PostgreSQL 9.2
yes
yes
-
-
PostgreSQL 9.1
yes
yes
-
-
PostgreSQL 9.0
yes
yes
-
-
PostgreSQL 8.4
yes
yes
-
-
PostgreSQL 8.3
yes
yes
-
-
PostgreSQL 8.2
yes
-
-
-
PostgreSQL 8.1
yes
-
-
-
Sybase SQL Anywhere 11
-
yes
yes
-
Sybase Adaptive Server 15.5
yes
yes
yes
-
Sybase Adaptive Server 15
yes
yes
yes
-
Sybase Adaptive Server 12.5.3
yes
yes
yes
-




Reverse engineering Reverse engineering

Connections Connections