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.


Rate this Solution

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs