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:

• Stop the Log360 UEBA application.
• Run command prompt as an administrator. Go to <Log360 UEBA Home>bin/backupDB.bat to backup the data available in the PostgreSQL database and wait for the backup to complete. By default, the backup file will be stored in <Log360 UEBA Home>backup directory with the file name 'backup_log360ueba_<Build_Number>_MM_DD_YYYY_hh_mm.data'.
• From the installed Microsoft SQL Server, copy the files bcp.exe and bcp.rll to <Log360 UEBA Home>bin folder.

Note: If you are copying the above file from a server with SQL Server version 2005 and above, to another server runnning Log360 UEBA, please install the following SQL Native Client in the Log360 UEBA machine based on the SQL Server version and CPU type of the Log360 UEBA machine.

Microsoft SQL Server 2008 (32-bit)

http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

Microsoft SQL Server 2008 (64-bit)

http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409

Microsoft SQL Server 2012

https://www.microsoft.com/en-us/download/details.aspx?id=50402

Microsoft SQL Server 2014

https://www.microsoft.com/en-in/download/details.aspx?id=36434

Microsoft SQL Server 2016

https://www.microsoft.com/en-us/download/details.aspx?id=50420

• Call into use the <Log360 UEBA Home>bin\changeDB.bat in command prompt to configure the Microsoft SQL Server credentials like server name, port, username, and password.

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.



For SQL Server authentication, enter the Username and Password.


• 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.