About automatic database generation

This article is useful in the following two ways: 1. When the database description documents are synchronized with the actual database structure. 2. When a descriptive document is generated based on the existing database structure. I usually generate the "database instruction document" in this way: method 1 (this is done in SQLServer2000) use this software SchemaToDocWithTableAnnotatorv2

This article is useful in the following two ways: 1. When the database description documents are synchronized with the actual database structure. 2. When a descriptive document is generated based on the existing database structure. I usually generate the "database instruction document" in this way: method 1 (this is done in SQL Server 2000) use this software SchemaToDoc With Table Annotator v2

This article is useful in the following two scenarios:

1. When the database instruction documents are synchronized with the actual database structure.
2. When a descriptive document is generated based on the existing database structure.

I usually generate the "database instruction document" as follows:

Method 1 (in SQL Server 2000)

Using this software "SchemaToDoc With Table Annotator v2.8.8", it is easy to find its registration machine on the Internet, so it is very convenient to use, and the database instructions it generates are also very professional.

Unfortunately, I cannot use it to connect to SQL 2005 or oracle 10 Gb;
Its Enterprise Edition "SchemaToDocEnterpriseInstall.exe" can be smoothly connected to SQL Server 2005 and oracle 10g. However, because there is no registration code, only three objects can be exported at a time (the objects here include stored procdure, view, table, function, etc )......

Method 2

Use PowerDesigner to export the PDM (Physical Data Model) graph from an existing database, analyze the PDM graph by using another tool PdmReader (which can be downloaded from http://www.pdmreader.com/), and then generate instructions.

The specific steps are as follows:

Part 1: Use PowerDesigner to generate a PDM diagram.

1. Open PowerDesigner, select "Reverse Engineer" from the "file" menu, and then select "DataBase ";
2. In the displayed dialog box, enter the name of the PDM file to be created, select the type of the database to be connected in the DBMS option, and click OK;

4. On the Connect to a data source screen, select the data source name, enter the user id and password to Connect to the target database in the input box, click Connect, and then click OK.

5. If the previous configuration is correct, you can now view the data objects in the current database, such as tables and views. All objects are selected by default. If you only want to export a few tables, you can remove the check box before the object you do not want to export, and click OK. PD will generate the PDM diagram of the selected object for you.

6. Save the generated PDM diagram.

Part 2: Use PdmReader to generate instructions

1. After generating a PDM image, open it with PdmReader. Note that when opening a PDM image with PdmReader, make sure that the image is not opened in PowerDesigner.
2. Click Create project. In the displayed dialog box, enter the project name and click OK;
3. Select the project name, click "Import Data Dictionary", select the generated PDM chart, and click "Open;
4. Select the pdm graph Link under the project name. A link named "Export dictionary to doc" will appear on the right. Click here.

This content is transferred to: http://www.cnblogs.com/aspsmile/archive/2008/08/05/1261130.html learning usage