Upgrade Guide

AuthorMichael Andersen Date12-10-2026 ProductBC2SQL

Table of contents

  1. 1Business Central
  2. 2Update BC2SQL app through “Admin Center”
  3. 3Azure – Update Webjob
  4. 4On-Premises – Update Windows Service
  5. 5Verify the upgrade

1Business Central

Open the BC2SQL Setup page in Business Central and click Set On Hold to set the status to “On Hold”.

2Update BC2SQL app through “Admin Center”

In the Dynamics 365 Business Central admin center, open the environment and click Apps.

In the BC2SQL row, click Install update.

Confirm the update with Yes.

Do not check “Schedule the update in the next update window” – leave it unchecked so the update is installed right away.

3Azure – Update Webjob

Use this section when running BC2SQL in Azure. If BC2SQL is hosted on-premises instead, use On-Premises – Update Windows Service.

Download the latest BC2SQL.zip here: BC2SQL.zip

The current version of the BC2SQL Webjob runs on .NET 10.0.

Log into https://portal.azure.com and open the BC2SQL Web App.

Select Webjobs, stop the existing BC2SQL Webjob and delete it.

Click Add and upload the new BC2SQL.zip as a Continuous Webjob.

The Webjob does not use appsettings.json – it is configured through Environment variables on the App Service (TargetSQLSystem, EnvironmentCode and the connection string). These settings, together with 64 Bit and Always on, belong to the App Service and are kept when the Webjob is replaced – they do not need to be set up again.

Confirm that the new Webjob is running without errors.

4On-Premises – Update Windows Service

Use this section instead of Azure – Update Webjob when running BC2SQL on-premises as a Windows Service.

Download the latest BC2SQL.zip here: BC2SQL.zip

The current version of the BC2SQL service runs on .NET 10.0. Make sure the .NET 10.0 Runtime is installed on the server before updating. It can be downloaded here:
https://dotnet.microsoft.com/en-us/download/dotnet/10.0
Multiple .NET runtimes of different versions can safely be installed side by side on the same server – installing the .NET 10.0 Runtime will not affect other applications using other versions.

Open an elevated (Run as administrator) Command Prompt or PowerShell and stop the service:

sc.exe stop BC2SQL
  1. Take a copy of the existing appsettings.json in the service folder, for example C:\BC2SQL.
  2. Extract the new BC2SQL.zip into the service folder and overwrite the existing files.
  3. Put the saved appsettings.json back, so the connection string and EnvironmentCode are kept.
Do not overwrite your appsettings.json with the one from the zip file – it contains your connection string.

Start the service again:

sc.exe start BC2SQL

5Verify the upgrade

To check right away, query the log in the SQL database. There should be no entries of type Error – only Info:

SELECT *
  FROM [BC2SQL].[Log]
  ORDER BY Id DESC
Need help? Contact info@bc2sql.com.