Migrating the built-in database server (PostgreSQL) to Microsoft SQL Server or another instance of a PostgreSQL Server.

Supported database migrations:

Supported database versions:

To migrate the built-in PostgreSQL to a different database, follow the steps listed below.

Backup PostgreSQL Data


Configure Microsoft SQL Server

Common Settings to be performed in Microsoft SQL Server


Providing credentials to other users in the domain

If not, right click the Logins, New Login and provide a corresponding user name. The New user must have the sysadmin server level role and database level role of db_owner.

Follow the steps to provide the sysadmin role permission:
Right click the user, click 'Properties'
Go to 'Server Roles' → Check sysadmin and click 'OK'

Note: Details about user roles: Refer the documents in the following links:
For Server Level Roles: http://msdn.microsoft.com/en-us/library/ms188659.aspx
For Database Level Roles: http://msdn.microsoft.com/en-us/library/ms189121.aspx


Server Role of the user should be 'sysadmin' and Database Role of the user should be 'db_owner'.
The members of sysadmin server role can perform any activity in SQL Server and have completes control over all database functions.
The members of db_owner database role can perform any activity in the database.


MS SQL Server in local computer

Copy the following files to <Log360 Home>\bin folder.


MS SQL Server in remote computer

Note: Please install the corresponding SQL Native Client / Command line Utilities in the Log360 machine as per the MS SQL Server version and CPU type of Log360 machine.


MS SQL Server Version

Command line Utilities and Native Client

2005

Download

2008

Download

2008 R2 (x64)

Download

2008 R2 (x86)

Download

2012

Download

2014

Download

2016

Download

2017

Download


After installing the Command Line utilities, please copy the following files:

Copy the files to <Log360 Home>\bin folder.

Windows Firewall Settings

If the Firewall is enabled in MS SQL Server machine, the TCP and UDP Ports need to be opened.

UDP Port is normally 1434.

To check TCP Port settings, open SQL Configuration Manager:


Migrate database

  1. Log in to log360 as an administrator.
  2. Navigate to Admin → General Settings → Database Settings → Database Configuration.
  3. Select Log360 under Component Name.
  4. From the Select Database Server menu, select the database server that you want to change to.
  5. If you select PostgreSQL Server, then:
  6. If you select MS SQL Server, then:
  7. Check the box against Migrate Existing Data to copy the data from your old database to the new database.

    IMPORTANT: Leave this box unchecked only if you want to change the database of a fresh installation of Log360 or its components.

  8. Click Save.