search cancel

Migrating from MySQL to MSSQL Database

book

Article ID: 201334

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Currently we are on proposal to upgrade the UIM from 9.2.0 to 20.3. Also we would like to use MSSQL 2016 as the database. We are now using MySQL 5.7. is there any guideline on how to migrating all data from mysql to mssql?

Cause

- Database migration

Environment

Release : 9.2.0

Component : UIM - DATA_ENGINE

Resolution

There is no officially supported procedure to migrate UIM data from MySQL to an Microsoft SQL Server Database (or between 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) so that you no longer require the old data.

Additional Information

As a reference for what its worth 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 SQL server to another.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/administering/move-the-uim-database-ms-sql-server.html

UIM Compatibility Matrix
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/installing/product-compatibility/ca-uim-compatibility-matrix.html

Note that the CABI TLS v1.2 feature is not supported for Microsoft SQL Server 2012, 2014, and 2016 when installed on Windows Server 2016.