[EA] DB Data Reverse Engineering

The earliest use of rose, and later the use of EA for UML design, very convenient. EA, ie Sparx Systems Enterprise Architect. EA provides users with a high-performance, intuitive work interface, combined with the latest UML 2.0 specification, to create advanced software modeling solutions for desktop staff, development and application teams. The product is feature-rich and cost-effective, and can be used to equip your entire workforce, including analysts, testers, project managers, quality control and deployment personnel. The various class diagrams designed by EA can generate various types of code, and code synchronization, reverse engineering, are very convenient. This is to introduce the reverse engineering of database design with EA, that is, given the SQL Server database and a set of tables, with the EA reverse engineering to generate these tables diagram, design, or class diagram. These tables are directly related to the relationship at a glance. Of course, it is also possible to design a database table schema with an EA, which can generate DDL database scripts. This article is about reverse engineering. Let's go!

First open the EA, create a new class diagram, type Diagram, and then right-click, "Import DB schema from ODBC"

Then click on the database name the one behind the name ... button, the popup box lets you select the ODBC link, which is the system's ODBC box. Select the Machine Data Source tab page and click on the "Create new" button.

When you select ODBC driver, be aware that SQLServer2005 should select SQL Native Client and SQLServer2000 to select SQL Server.

The other is the default option, the user name password that step is entered as required. One step to note is to select a database, or it will always be the master database. See:

After creation, select other settings, "Create new Object" or "Synchronize with existing object", etc., and then click "Import Imports".

After the database changed, or design changes, can be synchronized, very convenient.