We are trying to migrate the APM DB from Postgres to Oracle. We are currently on version 10.1. The Documentation has instructions on this one and says the following command, migration.sh needs to be run.
Run the migration.bat or migration.sh script as appropriate for your operating environment using the following arguments:migration -srcDatabaseName <database_name> -srcDatabaseType <database_type> -srcHost <hostname> -srcPort <port_number> -srcUser <username> -srcPassword <password> -tgtDatabaseName <datatargetname> -tgtDatabaseType <database_type> -tgtHost <hostname> -tgtPort <port_number> -tgtUser <username> -tgtPassword <password>
Has anyone been in this situation before and tried the above method? I hear that there are a lot of complications when we take this route. What would be the right approach? Thanks for the help in advance.
Converting to a discussion
As long as you follow the steps to setup the Oracle schema/user beforehand the process should run smoothly
Install and Configure the APM Database - CA Application Performance Management - 10.3 - CA Technologies Documentation
Sometimes the migration can expose data integrity problems (e.g. duplicates) in the source Postgres DB but we can normally help fix to those up if you raise a support case.
The alternative is to not migrate the data i.e.
Manage the APM Database - CA Application Performance Management - 10.3 - CA Technologies Documentation
Hope that helps
Thanks for the quick response Lynn, that's helpful .
With respect to the Alternate Route, "keep the old data in Postgres for historical reference outside of the APM UI.", Is there a way for us to get the old data in Postgres to the new DB in Oracle when taking this approach?
You could use the migration.sh script to import the DB data into one Oracle schema and then also export the DB configuration into a 2nd schema for ongoing use with APM.
Then you would also have the old data in the first Oracle schema for reference purposes.