Announcements
No record found.
Hi,
What is the best method to import 1 million data in Items Table - BC SaaS Environment
Thanks
Revanth
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.
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,260 Super User 2026 Season 1
YUN ZHU 1,515 Super User 2026 Season 1
AndrewThomas81 1,373
