Er Diagram From Sql Server 2012

A5: automatic generation of DB definition book and the ER diagram from the real DB in SQL Mk-2

Introduction

Everyone DB (database) definition document and ER diagram (Entity-Relationship Diagram) Do you made properly?

In my case, I will get on with development on that created the sure those documents in the case involved from the initial project, not making DB definition book and ER diagram that it is a project of the halfway participation! Also or there sometimes patterns that.

There is a high possibility not that perhaps the document that's the scene that has been put off are made the definition document created by the fact that ...... time to avoid being chased by the development in a document created quite, Well, reverse from the already real DB once you make automatically the DB definition book and ER diagram! ! I think it is very survive if possible that.

What is recommended at such time A5:SQL Mk-2 will be a tool called.

This tool, or run the SQL, it is possible that us to automatically generate leads by a simple operation in addition to DB definition book and ER diagram of the function directly to the DB that to edit the table.

A5: SQL Mk-2 Download

http://a5m2.mmatsubara.com/

please try downloading from the top of the page Download here.

After downloading, it is very easy because it only hit the A5M2.exe unzip the zip file.

Operating environment

Target

OS
Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10,Windows Server 2003, Windows Server 2008, Windows Server 2012

DB
Oracle,Microsoft SQL Server,IBM DB2,PostgreSQL,MySQL,OLEDB, ODBC

Since the target OS, such only Windows, even if asked to the people of Mac users touch the Windows on this occasion (sweat).

※ It seems there is also a case that runs on MAC but, so there is also a move not function that get used in Windows is still good.

procedure

1. Add Database

View Image

[Database] from the menu bar When you start the tool ⇒ will continue to add DB to connect and select Add or Remove Database.

Since the pop-up called Add or Remove database] is displayed when you click the Add (A)] is the following will be displayed.

View Image

This time I want to connect to a MySQL personal cloud server, select the [MySQL / MariaDB (direct connection) (M)].

View Image

to enter the connection information to the server in [registered the contents of the database]. (Terminal software you think that you can connect in a similar setting and when you connect, etc.)

When the DB to be connected without any problems in the Test Connection, to complete the registration and press [OK].

View Image

Then, it will be information of the real DB is displayed on the tool.

2.DB definition document generation

View Image

This time, try to generate a DB definition book and the ER diagram in the database that test_db that you created for the test.

[Database] ⇒ it will be displayed when you select below the table definition document creation].

View Image

When the schema to select the [test_db] at a table in the test_db select the table you want to create a definition document because it is displayed in a list. (Multiple tables can be selected)

In addition, please be selected depending on the situation so choose the Excel or HTML output method. This time I would like to output in Excel.

Preparation OK if you click the table definition document Create button.

View Image

us to automatically generate the DB definition document of the result immediately like this. It is very convenient to be me to create table list.

※ number of tables are often selected at the same time and attention it takes time in its own way!

By the way, If you leave as described the comment to the column and table when you CREATE a table, A5: it will appear in place of the logical table names and logical name when you generate a table definition statement on a SQL Mk-2 more easy-to-understand definition document can be output. (If you do not have to write a comment is blank)

                CREATE                TABLE                `tbl_user`                (                
                `user_id`                bigint                (                20                )                NOT                NULL                AUTO_INCREMENT                COMMENT                'user ID'                                ,                
                `name`                varchar                (                64                )                NOT                NULL                COMMENT                'user name'                                ,                
                `gender`                tinyint                (                4                )                DEFAULT                NULL                COMMENT                'gender'                                ,                
                PRIMARY                KEY                (                `user_id`                )                )                ENGINE                =                InnoDB                DEFAULT                CHARSET                =                utf8                comment                =                'User basic information table'                                ;

3.ER diagram generation

View Image

If you want to generate ER diagram, and then select the database] ⇒ [ER diagram] ⇒ [Reverse generation of ER diagram].

View Image

in Reverse ER diagram generation, click the reverse ER Generation Once you have selected the table you want to output to the ER diagram.

View Image

Then also here gave me easily generate ER diagram.

View Image

also right chestnut on the diagram ER displayed select Page Properties, necessary information so switched to also display types and physical names as described above by changing the display level it is possible to output to the ER diagram.

finally

Or has become the document is to postpone by all means development priority, the first place I think of whether Some engineers who consider unnecessary Nante document, makes it easy to overall understanding of the system if there is a DB definition book and ER diagrams or easy to notice problems, everyday from the idea to the habit that leave the document because I think that because I think it very useful to share information when developing members has increased may be using, for example, introduced here tool What is how.