Shenzhen team to develop a system in the North China side to push customers, in a patch, due to changes in the data dictionary, but the Shenzhen team did not give the database update script, only to the new version of the database creation script, in order to ensure that the client system has no loss of data, Can only find a way to do it: using PowerDesigner to reverse the new version of the database, apply this model to the existing database, the PowerDesigner will compare two versions of the difference, only update the difference without losing data.
The error was prompted when reversing the new version of the database:
Several reasons are found: The database driver version is incorrect, the ODBC configuration is incorrect, and so on, the last discovery is that the database name contains the symbol "." Caused by this problem, renaming the database name to remove the comma can be normal reverse.
PowerDesigner 16.5 tip: Unable to list tables issues when reverse engineering from SQL Server 2012