DX Application Performance Management

Expand all | Collapse all

APM DB migration from Postgres to Oracle?

  • 1.  APM DB migration from Postgres to Oracle?

    Posted 11-16-2016 05:28 PM

    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



  • 2.  Re: APM DB migration from Postgres to Oracle?

    Posted 11-16-2016 05:37 PM

    Converting to a discussion



  • 3.  Re: APM DB migration from Postgres to Oracle?

    Posted 11-16-2016 05:44 PM

    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



  • 4.  Re: APM DB migration from Postgres to Oracle?

    Posted 11-16-2016 05:52 PM

    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



  • 5.  Re: APM DB migration from Postgres to Oracle?

    Posted 11-16-2016 06:00 PM

    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.