DX Infrastructure Manager

Expand all | Collapse all

Change MSSQL to MySQL UIM Database

  • 1.  Change MSSQL to MySQL UIM Database

    Posted 07-23-2021 03:47 PM
    Hi Guys,

    We are thinking about changing our database technology from UIM, today we are using MSSQL 2012 and would like to move to MySQL 5.7.

    To make this change, would it just change the data_engine connection settings for the new database?

    Today our environment is like this:

    UIM: 9.0.2
    Primary Hub: Windows 2012 R2
    UMP: Windows 2012 R2
    DB: Windows 2012 R2 and MSSQL 2012 (SP3) Enterprise Edition

    Thanks.


  • 2.  RE: Change MSSQL to MySQL UIM Database

    Broadcom Employee
    Posted 07-26-2021 03:50 PM
    No, doing that will result in the data_engine pointing to a database server with no database. The database is created during the installation when the installer runs the scripts in the data_engine folder.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Change MSSQL to MySQL UIM Database

    Posted 07-28-2021 10:13 AM
    Hello David Michel and Dhanunjaya Rao Lakhinana

    Thanks for the clarification on this matter, it will help in our decision on the UIM update.


    Tks


  • 4.  RE: Change MSSQL to MySQL UIM Database

    Broadcom Employee
    Posted 07-28-2021 06:02 AM
    It is not recommended to change the data_engine connection as David mentioned. we recommend to have a fresh UIM installation with MS SQL Server as Backend.