Last updated: 2019-04-09

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.
Manual update button only available if there's an update to apply

Update Modal Example

IMConfig manually update

Config Database Example

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"IMConfig_Test" /TargetServerName:"localhost" /SourceFile:"C:\Program Files (x86)\Nodinite\Nodinite\UpdateClient\App_Data\files\versions\\IMConfig.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:"IMLog_Test_20180811" /TargetServerName:"localhost" /SourceFile:"C:\Program Files (x86)\Nodinite\Nodinite\UpdateClient\App_Data\files\versions\\IMLog.dacpac" /Properties:RegisterDataTierApplication=True /Properties:BlockOnPossibleDataLoss=False /Properties:BlockWhenDriftDetected=False /Properties:PopulateFilesOnFilegroups=False /v:CustomPathData="null" /v:CustomPathImagedata="null" /v:CustomPathIndex="null"

Remember to change to the version of the SQL Server Package and the path to the DACPAC file if you run this command not on the server with the Nodinite Update Tool.

Next Step