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 performing a manual update of Nodinite databases, the updater should preferably use the Nodinite Logging Service service account, or with an account that is sysadmin on the target SQL instance(s).

Click on the Manual update for the database to update to generate the command string for use from an elevated command prompt.
ManualUpdateButton
Manual update button only available if there's an update to apply

Update Modal Example

NodiniteConfig manually update

Make sure to select the appropriate version for the update

Config Database Example

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"NodiniteConfig_Test" /TargetServerName:"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