Skip to content

Business Central migration tools and when each one fits

Business Central migration tools are the features Microsoft provides for moving data into a new company. The cloud migration tool moves Dynamics GP, older NAV and on-premises Business Central data online. Configuration packages load master data and balances from any source. QuickBooks data migration apps, Edit in Excel, journals and APIs cover the rest. So picking the right tool depends mostly on where your data comes from.

Last updated

☁️Cloud migration

The cloud migration tool for GP, NAV and on-premises

The cloud migration tool is the main Microsoft route for existing Dynamics customers. You start it from the Cloud Migration Setup assisted setup in Business Central online. Then it connects to your source SQL database through a self-hosted integration runtime and copies data into the online tenant. After that, you run the data upgrade and check the companies.

It supports Dynamics GP, older Dynamics NAV versions through an upgrade path, and Business Central on-premises. For GP, you choose which modules and how much history to bring, and GP history can arrive as a snapshot for lookup. So this tool saves the most effort, but it only reads Microsoft sources.

Ask if the cloud tool suits you →
Rows of server racks in a data center
Cloud tool steps
  • ✓Run Cloud Migration Setup
  • ✓Install the integration runtime
  • ✓Pick companies and modules
  • ✓Replicate, then run the upgrade
  • ✓Check data and switch off sync
📦Config packages

Configuration packages: the general Business Central migration tool

Configuration packages are the flexible tool for any source system. In the Configuration Packages page you choose tables and fields, then export an Excel template. Next, you fill it with cleaned data from the old system and import it back. Finally, you validate the package and apply it, so the records land in Business Central.

Packages handle customers, vendors, items, the chart of accounts, dimensions and posting setup well. They also carry open documents and opening balances into journals, which you then post. Because packages check each field against Business Central rules, they catch bad codes early. Therefore we use them for Sage, Xero, NetSuite and most other sources.

Get help building packages →
Good package uses
  • ✓Chart of accounts and dimensions
  • ✓Customer and vendor cards
  • ✓Item cards and units
  • ✓Opening balance journals
  • ✓Posting group setup
🧩Data migration apps

Data migration apps for QuickBooks and other sources

For some small business systems, Microsoft offers data migration extensions that run inside Business Central. For example, the QuickBooks data migration apps bring over accounts, customers, vendors and items from QuickBooks Online or Desktop. You start them from the Data Migration assisted setup and follow the steps on screen.

These apps are quick for simple companies. However, they move master data and balances, not full transaction history, and they do not rebuild reports or workflows. So we often use them for the first pass, then add configuration packages for anything they skip. AppSource apps from partners also cover other source systems.

Check your source system with us →
What these apps move
  • ✓Chart of accounts
  • ✓Customers and vendors
  • ✓Items with basic details
  • ✓Opening balances
  • ✓No full transaction history
📊Excel and APIs

Lighter Business Central migration tools: Excel, journals and APIs

Smaller loads often need nothing more than Excel. Many list pages offer Edit in Excel, so you can add or change records in a sheet and publish them back. Likewise, general, item and fixed asset journals can be filled from Excel and posted, which suits opening stock counts and asset balances.

For large or repeated loads, the Business Central APIs and OData web services work better. An integration platform or a small script can push records in batches and log every error. Also, a custom AL extension with XMLports or report-based imports handles odd file formats. So each gap gets the lightest tool that does the job.

Plan the hard loads with us →
Lighter tools
  • ✓Edit in Excel on list pages
  • ✓General journal imports
  • ✓Item journal for stock counts
  • ✓APIs and OData for bulk loads
  • ✓AL extensions for odd formats
🧭Picking tools

How to choose Business Central migration tools for your project

Start with the source. A GP, NAV or on-premises Business Central customer should look at the cloud migration tool first. A QuickBooks company can try the data migration app. Everyone else plans around configuration packages. Then decide how much history you need, because history drives the size of every load.

Next, rehearse in a sandbox. Load everything, run trial balances and aged lists, and compare them with the old system. After that, fix the mapping and load again until the numbers match. Finally, schedule the live load at a period end. If you want a second pair of eyes, our consultants run these rehearsals with you.

Book a migration planning call →
Checks before go-live
  • ✓Trial balance matches
  • ✓Aged receivables match
  • ✓Aged payables match
  • ✓Stock value matches
  • ✓Users sign off test data
Questions

Questions about Business Central migration tools

Which Business Central migration tools are free?

The cloud migration tool, configuration packages, the QuickBooks data migration apps, Edit in Excel, journals and the APIs all come with Business Central. AppSource apps from partners and integration platforms carry their own fees. The main cost of any migration is the cleanup and testing time.

Can the cloud migration tool move data from Sage or Xero?

No. The cloud migration tool reads Microsoft sources only: Dynamics GP, older Dynamics NAV through an upgrade path, and Business Central on-premises. For Sage, Xero and other systems, we use configuration packages, journals and, where it helps, a partner migration tool.

Do migration tools bring over customizations?

No. Tools move data, not code. GP Dexterity changes, NAV modifications and custom reports must be rebuilt as AL extensions, standard features or Power BI reports. Therefore we list every customization early and decide what to rebuild, replace or retire.

Should we migrate all our transaction history?

Usually not. Most companies bring master data, open documents and opening balances, then summarized history for comparisons. Older detail stays in the old system or an archive for lookup. Loading less history keeps the new company fast and makes testing simpler.

Can we test a migration before going live?

Yes, and you should. Business Central sandbox environments let you run full trial loads without touching production. We usually rehearse the migration at least twice, compare reports with the old system each time and only then load the live company.

Book a discovery call

Let's talk through your move to Business Central.

A focused call with a senior consultant. We learn how your business runs today, give you an honest view on whether Business Central fits, and outline scope and next steps before you commit to anything.

What happens after you send the form

1
We read your request
A consultant reads your details before the call. There is no long questionnaire to fill in.
2
Discovery call
We go through your processes, your current systems and the problems you want solved.
3
Written plan and proposal
You receive a written proposal covering scope, phases and licensing.
✓A consultant replies by email
✓NDA available on request
✓No cost, no obligation
✓Senior BC consultants

Request your discovery call

Takes under a minute. A consultant replies by email.

Free

Your details stay with our consulting team. We never share or sell them.

▦ IndependentDynamics 365Business Central consultants
C Clutch5.0 from 1 reviewSataware on Clutch
G GoodFirmsParent company profileSataware on GoodFirms
S SatawareOur parent company14+ years, 1000+ projects listed
▦ IndependentDynamics 365Business Central consultants
C Clutch5.0 from 1 reviewSataware on Clutch
G GoodFirmsParent company profileSataware on GoodFirms
S SatawareOur parent company14+ years, 1000+ projects listed
Book a free call