Solutions
Dim cm : upgrade from 14.3.3 to 14.5.1 => How to estimate archive logs during upgrade process ?
| ID: | S143575 | |
| Published: | 12 October 2021 |
Product(s)
- Dimensions CM
Description
In order to estimate archive logs during upgrade process, DBA team wants to know list of changes in database in colums tables, indexes, views, ....
How can I find this information ?
Resolution
Sql scripts executed during the upgrade are located here : $dm_root/dbms/upgrade
The upgrade will execute the following SQL scripts in order they are listed.
upgradedb_1432.sql
upgradedb_1433.sql
upgradedb_14331.sql
upgradedb_14332.sql
upgradedb_1434.sql
upgradedb_144.sql
upgradedb_1441.sql
upgradedb_145.sql
upgradedb_1451.sql
As these sql script are plain text files, anyone can easily see how many tables/indices/columns are added.
