Is it possible to migrate the CA (Nimsoft) UIM database from MySQL to Oracle?
- UIM 8.x or higher
Unfortunately, it is not possible to migrate from MS SQL to Oracle with UIM. It would require a reinstall of the Primary hub and UMP, as well as Unified Reporter and/or CABI.
There is no officially supported/tested procedure to migrate UIM data from MySQL to an an Oracle database (or between DB platforms in general).
A number of our database objects have unique identifiers which are generated at the time of object creation and need to be matched up with identifiers in other tables; it is therefore not possible to merge objects from two databases, as the identifiers will not match afterwards and the data will be inaccessible/corrupted.
This applies to migrating between DB platforms as well. Currently there is no way to migrate from one database platform to another.
Generally speaking in the case of such a migration, we usually recommend that customers leave the old systems up and running for a certain time period for "historic" reporting purposes, until enough data has been accumulated in the new database (e.g. 3 months, 6 months, etc.) until’ you no longer require the old data.
As a reference, you may migrate between different versions of MS SQL Server - here is the supported procedure for migrating between versions of MS SQL server:
Move the UIM Database (MS SQL Server)
You can move the UIM database from one MS SQL server to another.
UIM Compatibility Matrix
You will need assistance and to leverage third-party expertise/your DBA when migrating between different DB vendors of you can solicit help from HCL Field Services by working through your Broadcom Account team. When finished, you can modify your data_engine configuration and restart the primary hub service.
Note that sometimes the database vendor can provide white papers/documents for migration guidelines/best practices in general.