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/admin-set-up-a-company-with-rapidstart
https://docs.microsoft.com/en-us/dynamics365/business-central/admin-migrate-customer-data
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!