Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
BC v25 Synchronization between Online Main Site and Offline Remote Sites
Med
Member Posts: 1
Hi Fiends,
I’m looking for a technical solution to synchronize two Business Central on-premises instances:
Main site: Full BC installation with all master data
Remote site: Local BC used for CMMS and inventory, with an unstable VSAT connection
Requirements:
One-way sync: Send master data (e.g., items) from the main site to the remote site
Two-way sync: Exchange transactional data like purchase receipts, transfers, stock adjustments, and production orders
The remote site must work autonomously, even offline, and sync reliably with the main site when the connection is available.
What technical solutions do you recommend for this setup?
APIs, data replication, middleware, or other?
Thanks in advance for your help
I’m looking for a technical solution to synchronize two Business Central on-premises instances:
Main site: Full BC installation with all master data
Remote site: Local BC used for CMMS and inventory, with an unstable VSAT connection
Requirements:
One-way sync: Send master data (e.g., items) from the main site to the remote site
Two-way sync: Exchange transactional data like purchase receipts, transfers, stock adjustments, and production orders
The remote site must work autonomously, even offline, and sync reliably with the main site when the connection is available.
What technical solutions do you recommend for this setup?
APIs, data replication, middleware, or other?
Thanks in advance for your help
0
Answers
🔧 Recommended Approach:
1. Integration via Web Services or APIs (with Local Buffering):
Use BC APIs or OData web services for sending and receiving data between sites. At the remote site, implement a middleware or service that:
Buffers data locally (e.g., using a local SQL or queue)
Sends/receives updates when the VSAT connection is active
Ensures retries and conflict handling during outages
2. Use Azure Service Bus or Queue-Based Middleware:
If cloud access is acceptable when online, you can:
Push data from both sites to an Azure Service Bus or similar messaging queue
Process it asynchronously once connections are available
3. File-Based Sync (for unstable connections):
Use scheduled jobs to export/import XML or JSON files via FTP/SFTP between sites. Trigger sync jobs via BC Job Queues or external scripts.
🧠 Tools to Consider:
Custom-built C/AL or AL code units for controlled export/import
Task Scheduler or Windows Services for sync logic
SQL Server Integration Services (SSIS) if you're open to SQL-level integration
3rd-party BC sync tools (like To-Increase Connectivity Studio or Tinx-IT) if budget allows
✅ Key Tips:
Use change tracking (modification timestamps or journal tables) to limit data transfer
Maintain data conflict resolution rules for two-way sync
Test with delayed/incomplete connections to simulate real-world VSAT behavior
This hybrid, loosely coupled sync approach gives you offline independence at the remote site while maintaining consistency with the main site once reconnected.
Let me know if you want help.