How does Visio reverse export database design documents?

If we want to migrate an old database system to a new database system, it is a great challenge to understand the data structure in the old database system, especially when we have to use early databases on other DBMS platforms, it is even more difficult.

The tools provided by visio enableProgramSmoother, it uses a powerful reverse engineering Wizard to retrieve a complete list of databases, including triggers, functions, inventory programs, query clauses, and other platform-specific types. In addition, we can easily modify the database design to meet new needs, or create charts and reports and share results with the project team.

 

1Supported Databases

To maximize elasticity, Visio supports a considerable number of databases, including master-slave databases (such as IBM, Informix, Microsoft, Oracle, and Sybase), and desktop databases (such as Microsoft Access and Corel paradox ).

2Database Design Based on Business Rules

If information professionals and general users speak the same language, the database design requirements are easily met. With Visio, we can describe business rules in a language that is meaningful to both general users and developers without worrying about implementation issues.

3Database engineering re-engineering

When we plan databases for today's IT projects (such as e-commerce or customer management systems), we need to base on existing DBMS, but not be blocked by their restrictions, visio has the power to recreate the database engineering we need.

4Collaborative operations of Working Groups

Large database design projects can be easily distributed to developers and team members. Using Visio to generate sub-models of the project, each developer can process a sub-section of the database, the centralized project file can combine the source model to display the complete state, map the changes in the data table and field name to the source model, and then generate a database outline. The team work is easier than ever.

Next, let's take a look at how to use reverse engineering.

1. Open Microsoft Visio Professional Edition. The "select drawing type" dialog box appears. Select "Database"> "database model diagram" from the "type" dialog box ". If you have enabled Visio, select "file", "new", "select drawing type", "Database", and "database model diagram" from the menu ".

2. Then, we will find an additional "Database" menu in the menu and select "Database"> "reverse engineering ".

3. The reverse engineering wizard dialog box is displayed.

4. In this dialog box, select the data source and select the appropriate driver.

5. Select "Data Source" as "Microsoft Access database" and click "Next ".

6. Then, the "connect data source" dialog box appears. Because the database created by the author has not set the Administrator and password, click "OK.

7. Copy the "sales. mdb" file in the CD example to the hard disk and remove the read-only attribute. However, select "connect to the" sales. mdb "file in" select database ", and click" OK "after the settings are complete ".

8. Next, the system will ask us what type of object we want to execute the reverse engineering. Generally, we do not need to change it. Click "Next!

9. Then, select the tables or query data to be imported to the Visio environment. One "T" is the table, and the other "v" is the query. Select all and then click Next.

10. Then, we can set whether to add the shape of the reverse engineering project to the current page or add it later. Here, we will not change it and click "Next ".

11. Click "finish" after completing the settings. In this simple step, you can switch the database to Visio!

 

5View and edit the database module

We can also add, delete, and modify tables, fields, and associations on the module.

In addition, you can change the status of the currently opened database module in the View window. Then, we will practice how to view and edit the database fields after reverse engineering.

6View database Properties

1. Select the "customer data" database on the page, right-click the database, and select "database properties ".

2. The "database properties" window appears.

Original article: http://hi.baidu.com/zjial1/item/9a0c44146c779fdfbf9042eb

However, reverse engineering is not available in Visio 2013.