Book demo

Choosing the Right Deployment Model

Learn more about BC2SQL deployment models, infrastructure options, and compatibility requirements.

Can BC2SQL run on-premise?
Yes. BC2SQL supports traditional SQL Server deployments hosted on-premise or in private infrastructure environments.
Can BC2SQL use Azure SQL?
Yes. Azure SQL is commonly used with BC2SQL and works well for cloud-first Business Central environments.
Does the deployment model affect BC2SQL functionality?
No. The BC2SQL synchronization engine and SQL structure are identical regardless of whether SQL is hosted in Azure or on-premise.
Can BC2SQL support hybrid environments? 
Yes. Some organizations use BC2SQL with hybrid infrastructure models depending on reporting, integration, or governance requirements.
Which deployment model is most common?
Both models are actively used. The best choice depends on existing infrastructure, SQL competencies, governance requirements, and operational preferences.
Does BC2SQL require Azure?
No. BC2SQL does not require Azure and can run entirely on customer-controlled SQL Server infrastructure.
Can existing SQL integrations be reused?
In many cases, yes. Organizations with existing SQL-based integrations often choose on-premise SQL deployments to simplify reuse of existing infrastructure and logic.

Choose your infrastructure

BC2SQL works in both cloud and on-premise. Choose what fits your existing setup.

☁️  Cloud (Azure SQL)
🖥️  On-Premise (Own SQL)
Cloud Setup
☁️
Azure SQL Database
Microsoft hosted
BC2SQL.exe
Runs on Azure VM or your server
Business Central
Cloud

Cloud – Azure SQL

Perfect if you don't have existing SQL licenses or want to avoid server maintenance.

Benefit

  • No hardware maintenance
  • Automatic backup and updates
  • Scalable as needed
  • Access from anywhere
  • No large upfront costs

Considerations

  • Monthly Azure cost
  • Requires internet connection
  • Data in the cloud (if that's a concern)
 

Recommendation

Choose Cloud if you don't have existing SQL Server licenses, or if you want minimal maintenance. Most new customers choose this solution.

Cloud Setup
🖥️
Own SQL Server
Your infrastructure
BC2SQL.exe
Runs on your Windows Server
Business Central
Cloud

On-Premise – Own SQL Server

Ideal if you already have SQL Server licenses and infrastructure you want to utilize.

Benefit

  • Utilize existing licenses
  • Full control over hardware
  • Data stays on-premise
  • No ongoing cloud costs
  • Integration with existing systems

Considerations

  • You handle backup and maintenance
  • Requires server capacity
  • IT department must maintain

Recommendation

Choose On-Premise if you already have SQL Server licenses and your IT department prefers to keep data internal. Ideal for companies with existing on-premise infrastructure.

How Deployment Works

Get connected in three simple steps.

1
BC Extension

Environment Setup

Configure companies, tables, and data sources directly inside Business Central with no custom development required.
2
BC2SQL Engine

Smart Data Sync

Our sync engine securely transfers and structures your data to Azure SQL or your private SQL Server.
3
SQL Database

Instant Data Access

Your data stays updated automatically, ready for reporting, analytics, and enterprise integrations.

Ready to access your data?

Book a no-obligation 15-minute demo. We'll show BC2SQL on your screen and walk through the features – whether you choose Cloud or On-Premise.

Built for Reporting, BI, and Integration Teams

The principles that guide everything we do at BC2SQL.

Cloud

  • Setup Time -Fast
  • Maintenance -Low
  • Scalability -High
  • Infrastructure -Managed
  • Remote Access -Easy

On-Prem

  • Setup Time -Medium
  • Maintenance -Manual
  • Scalability -Depends
  • Infrastructure -Self-hosted
  • Remote Access -Configurable
Copyright © 2026 BC2SQL. All rights reserved.
arrow-up