We need update existing clarity project from 13.0 to 14.1. Anyone know what is the process to migrate the database to 14.1 with customized data.
You just "upgrade Clarity" - that caters for all data, all custom-configurations etc.
Please check this -
You do not migrate the database. You upgrade your system.
Say you already have 14.1 sytem and just want to take the database from 13.0 and migrate that to 14.1. Sorry No can do.
You upgrade your 13.0 system to 14.1 and the backup and restore the databse if you still want to.
For instructions see the release notes and install guide for supported upgrade paths and requirements for jdk and tomcat etc. and instructions.
For an example for a similar upgrade (not exactly the same) see
CA Clarity PPM Support Webinar - Upgrading CA Clarity from 12.1.3 to 13.3
For more discussion search this forum for "upgrade".
You upgrade your 13.0 system to 14.1 and the backup and restore the database if you still want to.
I don't think it will work, right? I think CA did a lot change for the database schema, and our production database also did customization for default 13.0 database
CA schema changes are fully supported by any supported "upgrade path", as are any configurations that you have made through Clarity (custom Clarity objects etc).
An upgrade will not touch any totally custom objects (Z_ tables etc) that you may have added to the schema, the only problems you would encounter is where _you_ have made custom changes to the Clarity database objects themselves directly in the database itself (eg custom triggers) - which is why doing that has never been supported. For that you would "undo" any changes, then upgrade Clarity.
"I don't think it will work, right? I think CA did a lot change for the database schema, and our production database also did customization for default 13.0 database"
What part do you think will not work?
Have you created a system which in your opinion cannot bet upgraded?
Run the upgrade and if it fails because of changes you have made, roll back and undo the changes you have made and run the upgrade again.
If the backup and restore to another system running the same version of Clarity, but eg empty or fresh database does not work because of changes you have made to the Clarity file systems (I don't see why it should fail) make the same changes before restore.
Retrieving data ...