- 2 minutes to read

About manually updating the Configuration Database and Log Databases

Nodinite has built-in support for updating the Configuration database using the web-based Update Tool. The Log Databases, however, always needs to be manually updated. The reasons for manually updating either type of database are:

  • Security-related problems - A SQL DBA may be the only one with enough SQL rights to perform the operation
  • Long execution times - The Web-based Update Tool lacks support for long-running transactions and for obvious reasons you do not want to hog the client browser while waiting for the operation to succeed (or not)
  • Parallel execution - If you have many Log Databases

When you perform a manual update of the Nodinite databases, you should use the Nodinite Logging Service service account, or use an account that is a part of the sysadmin role on the target Microsoft SQL Server instance(s).

Click on the Manual update button on the database to update. This operation opens a modal with a script. Execute this script from a command prompt running as the service account used for the Logging Service:
ManualUpdateButton
The 'Manual update' button is only available if there's an update available.

This script requires that the DACPAC binaries are installed, please review the SQL Server Package (DACPAC) user guide.

Update Modal Example

First, make sure to select the appropriate version for the update. The version with the highest number is the default.
NodiniteConfig manually update

Config Database Example

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"NodiniteConfig_Test" /TargetServerName:remove all configurations using the"localhost" /SourceFile:"C:\Program Files (x86)\Nodinite\Nodinite\UpdateClient\App_Data\files\versions\5.0.0.0\NodiniteConfig.dacpac" /Properties:RegisterDataTierApplication=True /Properties:BlockOnPossibleDataLoss=False /Properties:BlockWhenDriftDetected=False

Log Database Example

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"NodiniteLog_Test_20180811" /TargetServerName:"localhost" /SourceFile:"C:\Program Files (x86)\Nodinite\Nodinite\UpdateClient\App_Data\files\versions\4.4.0.142\NodiniteLog.dacpac" /Properties:RegisterDataTierApplication=True /Properties:BlockOnPossibleDataLoss=False /Properties:BlockWhenDriftDetected=False /Properties:PopulateFilesOnFilegroups=False /v:CustomPathData="null" /v:CustomPathImagedata="null" /v:CustomPathIndex="null"

Next Step