[Er/studio] merges database structures of different versions

Difficulty coefficient: 0
Purpose:
This article introduces the ER/studio database modeling software, which is easier to use than Rose and Visio database modeling.
Powerdesigner has never been used without the error code of Erwin. Haha, I have never heard of it before :)

A system developed by the company because it is provided to customersCodeSo the customer conducted secondary development.
At the same time, for the sake of product scalability, our company has also carried out further development on it.
Later, as needed, the customer requested that we already haveProgramBased on our current program to upgrade its system.

The code modification on both sides is not very large, and VSS can be used to compare and confirm the difference.
However, for the convenience of statistics and query, the customer adds more tables and fields, and the database on our side has also undergone some changes.
The integration of databases has become a headache. Although there are many methods, such as importing SQL statements and comparing them.
However, the workload is not small. Later, ER/studio was used to solve this problem, which was relatively easy. It seems that there is a good tool.

1: first, reverse the two databases into two modeling files: model1.dm1 and model2.dm1.
2: Open model1.dm1 and follow the graph step by step. This is easy.

Before you click "finish" for actual processing, we recommend that you generate a report to check the merger.

Select the HTML format, which looks more convenient later

The key to merging is to delete a table that exists in the target table but does not exist in the source table,

If you want to retain the table, return a few steps to remove the check boxes of the tables.

After the selection, go to the final page and click "finish.

Note: if there are too many database tables, software exceptions may occur.

[Er/studio] merges database structures of different versions

Http://blog.csdn.net/babyt/archive/2004/08/31/89942.aspx