Support
 
Phone Get Quote
 
Support
 
US: +1 888 720 9500
US: +1 888 791 1189
Intl: +1 925 924 9500
Aus: +1 800 631 268
UK: 0800 028 6590
CN: +86 400 660 8680

Direct Inward Dialing: +1 408 916 9892

Migration

 

Steps to migrate/move- database, data, and product installation.

ADAudit Plus allows administrators to store and retrieve Windows servers' audit log data from MySQL, MS SQL, or PostgreSQL databases.
Outlined below are the steps for-

  • PostgreSQL/MySQL to MS SQL Migration

    By default, ADAudit Plus comes bundled with PostgreSQL database. To move the DB and/or data from PostgreSQL/MySQL to MS SQL, set-up the prerequisites first and then initiate movement.

    • 1. Configuring the MS SQL server

      • Open the SQL Server Configuration Manager on the computer running the MS SQL instance (to which the DB and/or data is to be moved).
      • In the left pane, click SQL Server Services --> Ensure that the SQL Server Browser is running.
      • In the left pane, click SQL Server Network Configuration --> Select Protocols for (the given instance) --> Enable TCP/IP.
        Note: The given instance refers to the MS SQL instance to which the DB and/or data is to be moved.
      • In the left pane, click SQL Native Client Configuration --> Select Client Protocols for (the given instance) --> Enable TCP/IP.
      • Restart the SQL Server Service.
    • 2. Providing permissions to the MS SQL instance

      The user account associated with ADAudit Plus must have access and appropriate permissions to the MS SQL instance (to which the DB and/or data is to be moved).

      Note: If SQL Server Autentication is used to move the DB and/or data, access and permissions to the MS SQL instace are automatically provided. However, when Windows Authentication is used, access and permissions have to be granted, as explained below-

      (i). To grant access- Login to Microsoft SQL Server Management Studio with a sysadmin account --> Select the server instance to which you will be migrating --> Security --> Logins. Check whether the user running ADAudit Plus is on the list-

      • If the user is already listed
      • If the user is not listed, right click on Logins --> New Login --> Create a new login

      (ii). To grant permissions- Right click on the user -> Properties -> Server Roles -> Check whether the user has sysadmin permission-

      • If the user does
      • If the user does not --> Select sysadmin in the checkbox and click OK

      Note: To grant the user only the minimum permissions required instead of sysadmin permission, right click on the user --> Properties --> User Mapping --> Select db_datareader, db_datawriter, db_ddladmin in the checkbox and click OK.

      • Also, execute the below query in the database: Right click on DB --> New Query --> GRANT CONTROL ON CERTIFICATE::[ZOHO_CERT] TO [newly_created_user]
    • 3. Enabling communication with the MS SQL server

      If ADAudit Plus and the MS SQL instance are running on different computers-
    • 4. Opening UDP and TCP ports (applicable only if the firewall is enabled in the MS SQL Server computer)

      • UDP port number is 1434.
      • To find the TCP port number, open SQL Server Configuration Manager on the computer where the MS SQL instance to which the DB and/or data is to be moved, resides. --> SQL Server Network Configuration --> Protocols for . Right click on TCP/IP --> Properties --> IP Addresses --> IPALL --> TCP Port Number.
      • Open the UDP and TCP ports under firewall settings.

    5.Move DB and/or data

    • Stop ADAudit Plus.
    • Invoke (ADAudit Plus Home)\bin\ChangeDB.bat in command prompt. Make sure that the user running the command prompt is same as the one running ADAudit Plus. ad-audit-plus-db-migrations-move-db-data
    • DB Configuration wizard will pop-up --> Select server type as MS SQL --> Select the Host Name, Instance Name, and Database Name. iv. If you want to migrate existing data from the PostgreSQL/MySQL to MS SQL, then select Yes for the Migrate Data option. Otherwise, select No (for a new installation of ADAudit Plus).v. Select the Authentication type. If you have selected Windows Authentication, the credentials are automatically taken. If you have selected SQL Server Authentication, enter the corresponding credentials.
      Note: If SQL Server Autentication is used to move the DB and/or data, access and permissions to the MS SQL instace are automatically provided. However, when Windows Authentication is used, access and permissions have to be granted, as explained in point 2 under pre-requisites.
    • Click Test Connection to check whether the credentials are correct.
    • Click Save.
      The migration procedure will start and it will take a few minutes to complete. Successful migration will end with the below screen- ad-audit-plus-db-migrations-procedure-start
  • Migrating data between different versions of MS SQL

    MS SQL server has built-in methods to migrate data from one version to another. Two of these methods are described below:

    1. MS SQL DB Migration using Detach and Attach Method

    Recommended for: Full DB backup, moving DB data to another drive, moving DB data between different versions of SQL server (Ex: SQL Server 2008 R2 to SQL Server 2012).

    • Login to Microsoft SQL Server Management Studio.
    • Right click on the DB that you want to move (Eg: adap). Select Task --> Detach.
    • In the Detach DB wizard --> Select both the check boxes (Drop Connections and Update Statistics) --> Ok.
    • Go to the DB storage path (Ex: C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA) --> Copy the .mdf and .LDF files (Ex: adap.mdf and adap_log.LDF).
    • Save both of the above files in a desired location.
    • Login to Microsoft SQL Server Management Studio.
    • Right click on the destination database and select Task --> Attach.
    • In the Attach DB wizard, click Add button.
    • Select the .mdf file from where it has been saved --> Ok (the .LDF file will get selected automatically).
    • Go to \conf folder --> Open database_params --> Change the SQL server location and DatabaseName, so that the product is pointed to the new DB.
    ad-audit-plus-db-migrations-detach-attach-method

    2. MS SQL DB Migration using Import Data Method

    Recommended for: Moving particular table data from one DB to another.

    • Login to Microsoft SQL Server Management Studio.
    • Right click on the DB that you want the data moved to (Ex: adap_new). Select Tasks --> Import Data.
    • The SQL Server Import and Export wizard opens up --> Click Next
    • In the Data Source wizard, that opens up, specify: (In the Data source drop down, select SQL Server Native Client if it's not selected already.)
      • Server Name.
      • Authentication (Used to login to SSMS).
      • Database.
      • Click Next.
    • Under the Destination wizard, enter the following: (In the Data source drop down, select SQL Server Native Client if it's not selected already. )
      • Server Name (will get automatically detected, you can change the destination, if you want).
      • Authentication.
      • Database (will get automatically detected, you can change the destination, if you want).
      • Click Next.
    • Under Specify Table Copy or Query --> Choose Copy Data From One or More Tables/Views --> Next.
    • Under Select Source Tables and Views --> Choose the tables to be copied from source, select the tables from the left column using Edit Mappings --> Select particular table operations --> Next.
    • Check the Run Immediately box--> Next.
    • Click Finish.
  • Moving ADAudit Plus from one server/drive to another
    • Stop the ADAudit Plus server (Start → Run → type services.msc → Stop "ManageEngine ADAudit Plus" ).
    • Stop the DB,
      Open a command prompt as an administrator
      Navigate to <installation dir>\ManageEngine\ADAudit Plus\bin
      Execute StopDB.bat
    • Remove the ADAudit Plus service,
      Open a command prompt as an administrator
      Navigate to <installation dir>\ManageEngine\ADAudit Plus\bin
      Execute the command : wrapper.exe -r ..\conf\wrapper.conf
    • Remove the ADAudit Plus - DataEngine service,
      Open a command prompt as an administrator
      Navigate to <installation dir>\ManageEngine\ADAudit Plus\apps\dataengine-xnode\bin
      Execute the command : dataengine-xnode.bat -r
    • Copy the entire ADAudit Plus folder to the new server or drive.
    • Ensure both folder sizes are the same.
    • Open the command prompt [with Administrative privileges] \ManageEngine\ADAudit Plus\bin --> Execute InstallNTService.bat.
    • If you want to start the product as service, go to Services.msc --> 'ManageEngine ADAudit Plus' Service --> Right click on properties --> Click on 'Log on' tab and select 'This Account' --> Provide the suitable credentials.

    Note: If you are using MS SQL server as your database and if the MS SQL server is running in a remote computer- Download and install SQL native client (sqlncli.msi), command line utilities (SqlCmdLnUtils.msi), and ODBC Driver (msodbcsql.msi); in the computer on which ADAudit Plus is running.

    Download the above files from the respective MS SQL server feature packs-

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

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

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

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

    Note: Native client, command line utilities, and ODBC driver version has to be the same as the MS SQL version (to which the DB and/or data is to be moved).

  • Migrating ADAudit Plus from 32-bit to 64-bit architecture
    • Check the product build number.
    • If it's not the latest build, upgrade your 32-bit version of ADAudit Plus to the latest build using the service pack below- https://www.manageengine.com/products/active-directory-audit/service-pack.html
    • Install the latest 64-bit version of ADAudit Plus in a different computer. Do not start the product.
    • Stop the 32-bit installation.
    • Provide a different name for the below folders in your 32-bit installation.
      • lib
      • jre
      • bin
    • Now copy the following folders from the 64-bit build installation folder and paste it into the 32-bit installation folder.
      • lib
      • jre
      • bin
    • Go to \ManageEngine\ADAudit Plus\conf folder in 32-bit installation.
    • Open product.conf file using Wordpad.
    • Change "product.processor_architecture" to 64.
    • Copy the wrapper.conf file from the location \ManageEngine\ADAudit Plus\apps\dataengine-xnode\conf\ in 64 bit installation and replace it in the 32 bit installation.
    • Start the 32-bit installation and re-apply the license file.

ADAudit Plus Trusted By

A single pane of glass for complete Active Directory Auditing and Reporting