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 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
-

Note: Support for the latest versions of selected database systems will be added to the product gradually. We plan to support the latest PostgreSQL database, for example. However, obsolete versions of this database system will not be supported in Toad Data Modeler. (Obsolete versions mean older versions of database systems. For example MS Access 97, InterBase 4, 5 and 6, MySQL 3.23, PostgreSQL 7 and others).

Supported databases - Toad Data Modeler 2

Database
Native
ODBC
ADO
Advantage 8
-
yes
yes
Advantage 7
-
yes
yes
DB2 version 8 UDB
yes
yes
yes
DB2 version 7 UDB
yes
yes
yes
DBISAM 3
yes
-
-
Firebird 1.5
yes
yes
yes
Informix 10
yes
yes
yes
Informix 9
yes
yes
yes
InterBase 7
yes
-
-
InterBase 6 SQL 3
yes
-
-
InterBase 6 SQL 1
yes
-
-
MaxDB 7.6
yes
-
-
MS ACCESS 2000
DAO 3.6
-
-
MS ACCESS 97
DAO 3.5
-
-
MS SQL 2005
-
-
yes
MS SQL 2000
-
yes
yes
MS SQL 7
yes
yes
-
MS SQL 6.5
yes
yes
-
MySQL 5.0
yes *
yes
-
MySQL 4.1
yes *
yes
-
MySQL 4
yes *
yes
-
MySQL 3.23
-
yes
-
Oracle 10g
yes
-
yes
Oracle 9x
yes
-
yes
Oracle 8x
yes
-
yes
Oracle 7x
yes
-
yes
Pervasive v9
-
yes 
yes
Pervasive V8
-
yes 
yes
PostgreSQL 8.1
yes **
yes
yes
PostgreSQL 8
yes **
yes
yes
PostgreSQL 7.4
yes **
yes
yes
PostgreSQL 7.3
yes **
yes
yes
PostgreSQL 7.1
-
yes
yes
Sybase Anywhere 9
-
yes
yes
Sybase Adaptive Server 15
yes
yes
yes
Sybase Adaptive Server 12.5.3
yes
yes
yes
Sybase Adaptive Server 12.5
yes
yes
-
Informix (older version)
-
-
-
Ingres
-
-
-
Clipper
-
-
-
Paradox
-
-
-


* MySQL - Native connection: The libmysql.dll has to be installed on your computer. Copy the files to the Windows system directory (c:/windows/system32 folder ) OR to the BIN directory of Toad™ Data Modeler (possible path: "C:\Program Files\Quest Software\Toad Data Modeler\Bin"). Important note: If you wish to connect to MySQL 4.1 or MySQL 5, use the libmysql.dll for version 4.0 and make one of the changes described at: http://dev.mysql.com/doc/refman/5.0/en/old-client.html

** PostgreSQL - Reverse engineering - Native connection: The following .DLL files have to be installed on your computer: libpq.dll, comerr32.dll and krb5_32.dll. These files are distributed with the PostgreSQL package (standardly at: "C:\Program Files\PostgreSQL\8.1\bin"). Copy the files to the Windows system directory (c:/windows/system32 folder ) OR to the BIN directory of Toad™ Data Modeler (possible path: "C:\Program Files\Quest Software\Toad Data Modeler\Bin"). For older versions of PostgreSQL, the libpq.dll file is required only.



Reverse engineering Reverse engineering

Connections Connections