Help Document

Migrate Log360 UEBA data from PostgreSQL to Microsoft SQL Server

This is applicable only if you are using Log360 UEBA with PostgreSQL and you want to change the database to Microsoft SQL Server.

The steps to migrate and run the Log360 UEBA server with Microsoft SQL Server as the database are given below:

Note:

To perform data migration, enter <Log360 UEBA Home>bin\changeDB.bat

  • The Database Setup Wizard opens. In the wizard screen, select Server Type as SQL Server. All the available SQL Server instances are listed. Select the Device Name and Port of the SQL Server from the instances.
  • DB migration can now be done. Choose Yes or No for Migrate Data.
    • Choose Yes for performing data migration along with the existing data.
    • Choose No for performing data migration without the existing data.
  • Select the authentication type using the Connect Using: option.
  • The options are:
    • Windows authentication
    • SQL Server authentication

    Note: Ensure that both Log360 UEBA and Microsoft SQL Server are on the same domain and logged in with the same domain administrator credentials.

    For Windows authentication, enter the Domain Name, Username and Password.

    win-authentication

    For SQL Server authentication, enter the Username and Password.

    sql-authentication
  • Click the Test button to check whether the credentials are correct. If the test fails, the credentials may be wrong. Recheck them and enter the correct credentials.
  • Click the Save button to save the SQL Server configuration. Please note that it might take a few minutes to configure the settings of the SQL Server.
  • Start the UEBA server to work with MSSQL Server as the database.