Validation and DACPAC Registration

In the new SQL Server instance, the Nodinite version in use needs to be correctly registered.

Register DACPAC

1. Use the Nodinite Install and Update Tool and navigate to the environment being moved (Prod/Test/Qa/...).
2. Verify the Nodinite Core Services are online.
3. Verify the Nodinite databases displays the 0.0.0.0 version.
4. For each Nodinite database, there is a Manual Update button.

1. Click the button to present a script.
2. Run this script from a CMD-prompt to update the version information according to the sections below.

Configuration Database

To register the DACPAC for the Configuration database follow the steps below.

1. Using a remote desktop session on the Nodinite Server with the Install and Update Tool, start a command prompt as the service account used as the installation account for Nodinite.
2. Paste the script for the configuration database and wait for it to finish (review the Manually update database user guide for additional information).

   Important

   If this step fails, please retry the operation at least once.

3. Validate registration by looking in the Install and Update Tool, the version number for Nodinite is now of the same version as before the move and the update button is no longer available.

Logging Database

To register the DACPAC for the Logging Database follow the steps below.

1. Using remote desktop on the Nodinite Server with the Logging Service, start a command prompt as the service account used for the Nodinite Logging Service
2. Paste the script for the logging database and wait for it to finish (review the Manually update database user guide for additional information).

   Important

   If this step fails, please retry the operation at least once

3. Validate registration by looking in the Install and Update Tool, the version number for Nodinite is now of the same version as before the move and the update button is no longer available
4. Repeat for each Logging Database

Start the IIS - Application Pools

Start all the stopped Nodinite application pools. Review the IIS Authentication settings user guide for additional information.

Important

Do NOT start the Windows Services yet.

Basic Validation Tests

The 'ProductArtifactsPath' System Parameter provides information about where the Nodinite Core Services are located.

Click on each of these links and validate that they are all still working:

Log API Test

Using the Install and Update Tool, locate the Log API quick link.

• Browse the Swagger interface or insert a JSON Log Event example, then verify it appears in the Admin Log View.

Web API Test

Using the Install and Update Tool, locate the Web API quick link.

• Using the Swagger feature, perform a test of the Get operations for Roles. All roles should be returned in the response JSON.

Web Client Test

Using the Install and Update Tool, locate the Web Client quick link.

• Perform a search in the Admin Log View and verify that there are Log Events in the search result.

Database Status Verification

From the Web Client verify the Server name(s) and database name(s) according to the new SQL Server environment. All Log databases should be listed as operational.

Next Step

Validation successful? Continue with final steps:

• Post-Migration Steps - Cleanup, backups, and monitoring

Related Topicsontal: Related Topics

• Database Migration Overview - Hub page and decision tree
• Planning - Pre-flight checklist
• Local Disk Move - For same SQL instance
• Remote SQL Instance Move - For different SQL instance
• Configuration Changes - Connection strings update