Reverse engineering database model diagram in Visio2010

Want to create a database model diagram, but there is no ready-made Visio template? Don't worry, PHP editor Baicao brings you a Visio2010 reverse engineering modeling tutorial. This tutorial details how to leverage the power of Visio to take data from an existing database and transform it into clear, intuitive model diagrams. Follow our steps to create professional database model diagrams step by step to assist your database design and analysis.

1. Create a new database model diagram in Visio

Open Visio 2010, File -> New -> Database -> Database Model Diagram. After creating the database model diagram, there is an additional menu item [Database] in the menu bar.

Look at the picture below. There is an extra database item in the menu bar

2. Reverse engineering

Menu item database— "Reverse Engineering. Start the reverse engineering wizard and complete the reverse engineering settings step by step.

2.1. Establish a connection with the database.

The type of Visio driver selected determines the type of database that can be connected and the available options. The data source specifies the database location and connection information. Here we choose the Visio driver as Microsoft Sql Server and the data source as the newly created BASICDATA.

2.2 Create a new data source

If the data source has not been established in advance, you can click [New] to create a data source.

2.2.1 Select [SQL Server] here

2.2.2 Set [data source name] and [server address]

server address It can be a server name or an IP address.

2.2.3 Test whether the data source is connected successfully

2.2.4 The data source is established successfully

The data source is established successfully , automatically jump to the [Reverse Engineering Wizard], and you will find that there are more newly created data sources in the [Data Source] list.

3. Connect to the data source

Enter the user name and password to connect to the data source.

4. Select the object type to be reverse engineered, as shown in the figure:

5. Select the table or view to be reverse engineered .

6. Select the stored procedure to be reverse engineered.

7. Check whether the content you selected is correct.

8. Do you want the items with reverse engineering selected to be added to the current project? Select Yes to generate the graph.

9. The result is roughly as follows.

This completes the introduction to the establishment of the database model! Look at an exported database model diagram:

The above is the detailed content of Reverse engineering database model diagram in Visio2010. For more information, please follow other related articles on the PHP Chinese website!