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

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.