APM DB migration from Postgres to Oracle?

[Kiran Tirupati]

Hi There,

 

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.

 

Thanks

[Hallett German]

Converting to a discussion

[Lynn Williams]

Hello,

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.

• just export the APM configuration (configexport.sh) and then import it into the new Oracle DB (configimport.sh)
• keep the old data in Postgres for historical reference outside of the APM UI.

Manage the APM Database - CA Application Performance Management - 10.3 - CA Technologies Documentation 

 

Hope that helps

 

Regards,

 

Lynn

[Kiran Tirupati]

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?

 

Thanks

[Lynn Williams]

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.