Skip to main content

Console Migration Workflow: Step 2—Prepare the Database

NOTE: Return to the main workflow page via this link: Console Migration Workflow.

Return to the previous section via this link: Console Migration Workflow: Step 1—Staging the Backup.

Proceed to the next section via this link: Console Migration Workflow: Step 3—Rebuild the Console.

Overview​

This article lists the steps to prepare the Netwrix Access Analyzer database for the Access Analyzer Migration.

New Access Analyzer Console Server Host Name​

For Host Management and Host List Replication, follow these steps to restore the backup of the Access Analyzer console to a new server.

IMPORTANT: This only applies if the new server name differs from the old server name; otherwise, skip to Access Analyzer Console Migration Workflow: Step 3 - Rebuild the Console.

On the Access Analyzer Database, copy the script below and configure the OldServer and NewServer values (lines 5 & 6, below), then run:

  1. Copy the SQL script shown below.
  2. Edit the Set @OHost = 'OldServer' and Set @NHost = 'NewServer' lines to match your old and new server host names. Leave the apostrophes.
  3. Run the script against the Access Analyzer database.
Declare @OHost varchar (128)
Declare @NHost varchar (128)

-- Configure the correct server names below. Leave the apostrophes!
Set @OHost = 'OldServer'
Set @NHost = 'NewServer'

Update [HostMaster_SANodeFilter]
SET SA_Node = @NHost
Where SA_Node = @OHost;

Update [HostListsTbl]
SET SA_Node = @NHost
Where SA_Node = @OHost
and ListID not in (Select ListID from [HostListsTbl] where SA_Node = @NHost);

Update [QueryTbl]
SET SA_Node = @NHost
Where SA_Node = @OHost;