DX Infrastructure Manager

Expand all | Collapse all

UIM Data Migration from MSSQL to MySQL

Jump to Best Answer
  • 1.  UIM Data Migration from MSSQL to MySQL

    Posted 03-03-2016 07:57 AM

    Dear Community

    We are planning to migrate UIM Data from MSSQL to MySQL
    Can anyone share his experience with that kind of Migration or give some insights about how it was done?

     

    Any feedback is very much appreciated

     

    Regards

    Andrea



  • 2.  Re: UIM Data Migration from MSSQL to MySQL
    Best Answer

    Posted 03-20-2016 08:38 PM

    As far as I know, there is no supported procedure by CA to migrate UIM data from MSSQL Database to MySQL.

    It is strongly recommended to do new UIM installation against MySQL server and migrate the collected QoS data. To do this, make sure to export/import the following tables before inserting QoS data into the new database:

     

    S_QOS_DEFINITION

    S_QOS_DATA

    all RN_QOS_DATA_% tables