Upgrade database version
To upgrade SQL Server version:
Back up the CDP metadata database and the user database.
Export the metadata using
CDP43_meta_export.bat
. This file is available in the upgradeScripts folder of the extracted CDP installer.Uninstall CDP. Refer to Uninstall CDP for details.
Upgrade the lower version of SQL Server database to higher version of SQL Server database. Refer to Upgrade CDP for details.
Change the compatibility mode of the metadata database and the user database to the corresponding upgraded database version.
Install the same CDP version that was installed on the lower version of SQL Server before upgrading to higher version. Use the same metadata database name from the version you are upgrading from.
Manually delete all data from the
ING_PROPERTY
table.Import the exported metadata using
CDP43_meta_import.bat
. This file is available in the upgradeScripts folder of the extracted CDP installer.Note
Ignore the error messages related to bulk tables while running the upgrade scripts.
Upgrade CDP to the latest version.