BC2SQL.COM

Upgrade Guide

BC2SQL
ProductBC2SQL Applies toAll versions

Table of contents

  1. 1Before you begin
  2. 2Upgrade the Business Central app
  3. 3Upgrade the .NET component
  4. 4Update SQL Scripts
  5. 5Verify the upgrade

1Before you begin

This upgrade guide is a placeholder. Replace the steps below with the real upgrade procedure, or provide an upgrade document to have it converted.
  • 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

Set the BC2SQL Setup status to “On Hold” before upgrading to stop data synchronization.

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.
Need help? Contact info@bc2sql.com.