[ERStudio] Make a different version of the database structure

xiaoxiao2021-03-06  81

Difficult coefficient: 0 This article: Introduction ER / Studio database modeling software, feeling more than Rose and Visio database modeling without erwin garbled, PowerDesigner has been useless, huh, huh, I have never seen it :) Company development A system, because it is provided to customer code, so the customer has developed secondary. At the same time, for the extension of the product, our company itself has further developed it. Later, as needed, customers require us to upgrade their systems based on our programs. The code modification amplitude on both sides is not very large, and the VSS can be used to confirm the difference. However, customers have added more tables and fields for statistics and queries, and the database of our side has also made some changes in the database, huh, huh, although there are many ways, such as: Guaranteed SQL statements, comparison, but workload is not small. Later, using ER / Studio solved this problem, relax, it seems that there is a tool for a hand. 1: First, the two databases are reversed into two modeling files Model1.dm1 and model2.dm12: Open Model1.dm1, then step by step by step, it is easy. Before you click "Finish", it is recommended to be Report, check the merger to select the HTML format, and it will make it easy to merge, the key is that if you will delete the target table, the source table is deleted, If you want to keep it, return a few steps to remove the hook of these tables out and then advance to the last interface to click "Finish" to operate. Note: If there are too many database tables, the software exception can be triggered.

转载请注明原文地址:https://www.9cbs.com/read-121620.html

New Post(0)