Dynamics Business Central / NAV Developer Digest - Vol. 509
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes Q&A on migrating BC to the cloud, Tackling the Full-Text Search requirement in BC 25, and advice on using NuGet.
The Dynamics 365 Business Central community, consisting of developers, project managers, and consultants, collaborates across various platforms to share valuable insights. At ArcherPoint, we greatly value their dedication and expertise. To ensure widespread access to this technical knowledge, we created Developer Digest.
Cloud migration Q&A
Considering migrating Business Central to the cloud?
Stefano Demiliani shares questions he received after his session at Directions EMEA provides an excellent FAQ on the subject.
Questions addressed:
- What’s the minimum SQL Server supported version for migration?
- Can I migrate an on-premises database and exceeding the storage space?
- Must change tracking be enabled on every database tables?
- Are Tenant Media migrated?
- How would you move a large on-prem SQL database to Azure SQL?
Read Demiliani’s blog, Dynamics 365 Business Central: Cloud Migration FAQ (Directions EMEA version), to find the answers to these and other Business Central cloud migration questions.
Tackling an upgrade to BC 25: Full-Text Search requirement
Mohana Yadav shares an incident his team encountered during an upgrade to Business Central 2024 Wave 2 (BC 25), receiving the following error text:
Error: “Text optimized index cannot be created/queried because the SQL Server Full-Text Search component is not installed. Please install the SQL Server Full-Text Search component and try again.”
As Mohana points out, “This error message, which some may encounter during their upgrade process, indicates that the SQL Server Full-Text Search component must now be installed for Business Central 25.”
Mohana offers complete instructions on how to install the Full-Text Search feature and proceed with the Business Central update without incident.
Read Mohana’s blog, Ensuring a Smooth Upgrade to Business Central 25 – SQL Server Full-Text Search Requirement, to learn more.
Using NuGet
NuGet is a versatile mechanism supported by Microsoft that is used for sharing .NET code. NuGet defines how packages are created, hosted, and consumed. But NuGet can do a whole lot more!
Erik Hougaard offers a great overview of NuGet and how it’s used in his video, Spread some NuGet love on your apps!
Developer tip of the day
Developer Tip of the Day: DataAccessIntent
Kyle reminds us to use DataAccessIntent = ReadOnly in our reports and queries if those objects do not need to write to the database. BC will optimize that to use a read-only database copy for improved performance.
Are you interested in Dynamics NAV and Business Central development? Check out our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.