Supported DBMSs

Modeling and reverse engineering of database schema is supported for the following DBMS products:

·DB2
·Firebird/InterBase*
·Informix
·Ingres
·MS Access 97, 2000, 2003
·Access 2007
·MS SQL Server 2000, 2005, 2008, 2012
·SQL Server Express 2005 and 2008
·MySQL
·SQLite
·Oracle 9i, 10g, 11g, 12c
·PostgreSQL
·Sybase Adaptive Server Anywhere (Sybase ASA)
·Sybase Adaptive Server Enterprise (Sybase ASE)

 

Notes

·* Firebird 1.5 database Tables can be modeled and generated as InterBase Tables; Firebird Tables can be imported, but are treated as InterBase Tables
·You can download data types for SQL Server (2005, 2008, 2012) Informix and MS Access 2007 from the Resources page of the Sparx Systems web site
 

Learn more

·Resources & Tutorials (online resources)