In a simple three stage process, migrate the PostgreSQL data and run the ADAudit Plus Server with MS SQL Server.
You can also change the backup directory. Execute the batch file to backup by passing the absolute path of the directory as argument in the command prompt.
Common Settings to be performed in MS SQL Server
Open SQL Server Configuration Manager.
Goto ‘SQL Server Services’ and ensure the service 'SQL Server Browser' is running.
Goto SQL Server Network Configuration > Protocols for SQLEXPRESS (the given instance while configuring the MS SQL) > Enable TCP/IP. Then restart the SQL Server (SQLEXPRESS - the given instance) Service.
Set the following configuration for the SQL Server Configuration Manager:
SQL Server Network Configuration > Protocols for [instances] > Enable everything.
SQL Native Client Configuration > Client Protocols > Enable all.
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:
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 <ADAudit Plus Home>\bin folder.
MS SQL Server in remote computer
Note: Please install the corresponding SQL Native Client / Command line Utilities in the ADAudit Plus machine as per the MS SQL Server version and CPU type of ADAudit Plus machine.
After installing the Command Line utilities, please copy the following files:
Copy the files to <ADAudit Plus 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 the TCP Port settings open SQL Configuration Manager:
SQL Server Network Configuration > Protocols for <instances>
Invoke the <ADAudit Plus Home>\bin\ChangeDB.bat in command prompt, to configure the MS SQL SERVER credentials like ServerName, Port, UserName and Password.
For Windows Authentication, the credentials of the Domain user are automatically taken.
For MS SQL Server Authentication, enter the User Name and Password.
Executing the restoreMigratedSQLData.bat will delete the existing data, if any.