Automatically generate Schema Design and relational diagram (class diagram) for all tables in the SQL Server database using EA (Enterprise impact ect)-Reverse Engineering

Rose was first used, and EA was used for UML design, which was very convenient. EA, that is, sparx systems enterprise effecect. EA provides users with a high-performance and intuitive working interface, and works with the latest UML 2.0 specifications to create advanced software modeling solutions for desktop computer staff, Development and Application teams. This product is rich in features and highly cost-effective. It can be used to equip your entire team, including analysts, testers, project managers, quality control and deployers. Various types of diagrams designed by EA can generate various typesCode, And code synchronization, reverse engineering, are very convenient. Here we will introduce the reverse engineering of database design using EA. That is to say, given the sqlserver database and a set of tables, the EA reverse engineering will be used to generate the relationship diagram and design diagram of these tables, or class graph. The direct relationships between these tables are clear at a glance. Of course, you can use EA to design the table schema of a database in a forward way. You can generate DDL database scripts. This document describes reverse engineering. Start!

First open EA, create a class chart, class digoal, right-click, "Import dB schema from ODBC"

Then click the database name behind the database name... Button. The ODBC link is displayed. Select the tab page of machine data source and click "new.

When selecting ODBC driver, note that "SQL native client" should be selected for sqlserver2005, and "SQL Server" should be selected for sqlserver2000 ".

Others are the default options. Enter the user name and password as needed. Please note that you should select the database. Otherwise, the database will always be the master database. See:

After creation, select other settings, "create new object", "synchronize with existing object", and click "Import.

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