Share
ReportHi,
What is the best method to import 1 million data in Items Table - BC SaaS Environment
Thanks
Revanth
You’re offline. This is a read only version of the page.
55
Hi,
What is the best method to import 1 million data in Items Table - BC SaaS Environment
Thanks
Revanth
Hello,
Below are ways to import data in business central
1.Configuration Packages
2.Web service(insert call)
3.Xml port
first and second way are not useful to import millions of records, performance wise XML port is very fast to import millions of records.
Signed, Sealed and Delivered.
Don't forget to help the community by Verifying the answer and Like it if your question has been answered. It will let others know that the topic has verified answer.
Thanks & Regards,
Ankit Shah(MCT-Microsoft Certified Trainer || Dynamics 365/Business Development Manager)
Follow/Connect 101 on below
LinkedIn:- https://linkedin.com/in/dynamicpower101/
Twitter:- https://twitter.com/Dynamicpower101
Facebook:- https://facebook.com/DynamicPower101/
Telegram:- https://t.me/dynamicpower101
Medium:- https://medium.com/dynamicpower101
Standard way offers you Edit in Excel and Configuration Packages. Both are slow and not recommended for large data.
The reasonable option is to develop XMLPort. The time needed to develop the XMLPort is still faster compares to waiting for the data to be imported the standard way.
Would think most will say xmlport here. I think multiple batches will still be needed. Doing this volume with configuration packages will be far too many batches.
If you’re migrating from a prior NAV version there are migration tools on offer there too.
#1
YUN ZHU
616
Super User 2025 Season 1
#2
Mansi Soni
463
#3
Sagar Dangar, MCP
391
All responses (
Answers (
