Data Migration from NAV to Business Central OnCloud – Part I

Hi guys,

I found a nice post on “AL ISSUE” page about Data Migration from NAV to Business Central (OnCloud), a very GOOD question (my opinion).

https://github.com/Microsoft/AL/issues/2476

User Question

“My question relates to a customer switching to the new Business Central solution. A customer wants to switch from his Azure Cloud NAV database to the new version Business Central but wants to take all his data with him. What is a scenario for migrating the data in the future? Is there a connector for such a change? Will there be a data migration tool from Microsoft?”

Microsoft Answer

This is something we are currently working on in the development team so customers will have a path for migration. Stay tuned to get more details around this process as we are still defining exactly how we will be able to migrate those customers’ data!

Thanks
Microsoft Dynamics SMB R&D

My Question @Today

…waiting for answer!

 

ANYWAY …. DATA MIGRATION TOOLS @TODAY

#1, Data Import

Data Migration Wizard (with Excel)

 

USE RapidStart for Data Migration IS the suggested solution by Microsoft

https://docs.microsoft.com/en-us/dynamics365/business-central/across-import-data-configuration-packages

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-set-up-a-company-with-rapidstart

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-how-to-use-the-rapidstart-services-role-center-to-track-progress

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-use-templates-to-prepare-customer-data-for-migration

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-migrate-customer-data

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-tips-and-tricks-rapidstart-services

 

No Official Backup\Restore Database Solution @today

  • No Access to SQL Server
  • Microsoft create backups with its policies, you can request a restore if necessary

No Export\Import Data from Pages (PAGES ARE NOT AVAILABLE IN ALL BC LOCALIZATIONS)

take a look to nice Post by Archer https://moxie4nav.wordpress.com/2018/07/22/d365bc-data-backups/

No Powershell and Powershell Database Functions

NO Import .NAVDATA, EXPORTDATA, IMPORTDATA from Powershell

  • THESE FUNCTIONS ARE NOT AVAILABLE
  • Powershell is not available

 

#2, Data Export Solutions & Export Data for Power BI – Workarounds

If you need to export your data (not in backup format), we have 3 solutions @today

#2.1 – you can use the “Edit In Excel” action (on most list screens) for this.

#2.2 – you can generate a configuration package that contains data from several tables

#2.3 – you can use the “Create Data Set” action from the Web Services screen to create a connection for exporting data from the tables within Financials.  This is very useful (and convenient) for a number of uses. If you are mainly interested in analyzing data with an external analysis tool (e.g. Power BI), I think you’ll find this to be especially useful. (the best solution in my opinion).

Example for 2.3

….WAITING FOR THE NEW TOOLS!

Leave a Reply

Your email address will not be published. Required fields are marked *

10 − three =

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enjoy this blog? Please spread the word :)

%d bloggers like this: