About manually updating the Configuration Database and Log Databases
Easily keep your Nodinite environment secure and up to date—even in complex or restricted SQL Server environments. This guide explains how to manually update the Configuration Database and Log Databases using DACPAC and the Update Tool, ensuring business continuity and compliance.
✅ Enables updates in highly secure or restricted SQL environments
✅ Supports parallel updates for multiple Log Databases
✅ Avoids browser timeouts and long-running web transactions
✅ Step-by-step, command-line instructions for full control
Nodinite provides built-in support for updating the Configuration Database using the web-based Update Tool. However, you must always manually update the Log Databases. Manual updates are also required in scenarios such as:
- Security restrictions—only a SQL DBA has sufficient rights to perform the update
- Long execution times—web-based updates may time out or block the browser
- Parallel execution—updating many Log Databases at once
When performing a manual update, use the Nodinite Logging Service service account or an account with sysadmin rights on the target Microsoft SQL Server.
To start a manual update:
- Click the update button ( or ) in the Update Tool.
- A modal window opens with a ready-to-run script.
- Run this script from a command prompt as the Logging Service account.
Here's an example of the 'Manual update' buttons.
You must have the DACPAC binaries installed. See the SQL Server Package (DACPAC) user guide for details.
Update Modal Example
Select the appropriate version for the update. The default is the highest available version.
Example of the update modal for the Configuration Database.
Config Database Example
The following is a sample command for updating the Configuration Database:
"C:\Program Files\Microsoft SQL Server\170\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"NodiniteConfig_Dev" /TargetServerName:"localhost" /SourceFile:"C:\Program Files\Nodinite\Nodinite Update\UpdateClient\App_Data\files\versions\6.1.0.37\Nodinite.ConfigDatabase.dacpac" /SourceEncryptConnection:true /TargetEncryptConnection:true /SourceTrustServerCertificate:false /TargetTrustServerCertificate:true /Properties:RegisterDataTierApplication=True /Properties:BlockOnPossibleDataLoss=False /Properties:BlockWhenDriftDetected=False /Properties:DropIndexesNotInSource=True /Properties:DropConstraintsNotInSource=True /Properties:ScriptNewConstraintValidation=False
Ignore DACPAC Options
New 6.1.0.4
Check the Ignore DACPAC Options box to skip database options like collation and recovery mode during the update.
Log Database Example
"C:\Program Files\Microsoft SQL Server\170\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"NodiniteLog_Dev_20220104" /TargetServerName:"localhost" /SourceFile:"C:\Program Files\Nodinite\Nodinite Update\UpdateClient\App_Data\files\versions\6.1.0.37\Nodinite.LogDatabase.Full.dacpac" /SourceEncryptConnection:true /TargetEncryptConnection:true /SourceTrustServerCertificate:false /TargetTrustServerCertificate:true /Properties:RegisterDataTierApplication=True /Properties:BlockOnPossibleDataLoss=False /Properties:BlockWhenDriftDetected=False /Properties:PopulateFilesOnFilegroups=False /Properties:DropIndexesNotInSource=True /Properties:DropConstraintsNotInSource=True /Properties:ScriptNewConstraintValidation=False /v:CustomPathData="null" /v:CustomPathImagedata="null" /v:CustomPathIndex="null"