1Before you begin

• Note your current BC2SQL version (Business Central app and .NET component).
• Take a backup of the BC2SQL SQL database.
• Schedule a maintenance window – synchronization should be paused during the upgrade.
• Download the latest release from the folder \LatestVersion in the link below.

Deploy

2Upgrade the Business Central app

• Download the new .APP file from \LatestVersion\BusinessCentral.
• In Business Central open Extension Management > Manage > Upload Extension.
• Select the new .APP file and choose Schema Sync Mode “Add”.
• Click “Deploy” and wait for the installation to finish.
• Verify the new version on the “Installation Status” page.

3Upgrade the .NET component

Azure Web App

• Download the new BC2SQL.zip from \LatestVersion\.NET.
• In the Azure Web App, stop the existing Webjob.
• Remove the old Webjob and add the new BC2SQL.zip as a triggered/continuous Webjob.
• Keep the existing appsettings.json connection string (re-enter it if required).
• Start the Webjob and confirm it runs without errors.

On-premise service

• Stop the BC2SQL Windows service.
• Replace the files in C:\BC2SQL_Service\ with the new release.
• Start the service again.

net stop BC2SQL
rem replace files in C:\BC2SQL_Service\
net start BC2SQL

4Update SQL Scripts

If the release includes database changes, run the latest CreateBC2SQLTables.sql / migration scripts from \LatestVersion\.NET\ against the BC2SQL database.

• Open Microsoft SQL Server Management Studio and connect to the BC2SQL database.
• Open a new Query and run the update scripts for this version.
• Review the messages output to confirm the scripts completed successfully.

5Verify the upgrade

• Set the BC2SQL Setup status back from “On Hold” to active.
• Confirm data starts synchronizing to the SQL database.
• Check the BC2SQL logs for errors.