Skip to main content


Showing posts with the label SQL Server

Migrating Data from Business Central On-Premise to Business Central Online

Introduction: After the Business Central On-Premise is ready with the Customization and Data, it's time to migrate the Business Central On-Premise Environment to Business Central Online(Cloud). The end goal in mind is to migrate to Business Central Online(Cloud) Pre- requisites : - Microsoft Dynamics Business Central(On-Prem & Online) - SSMS - Microsoft Azure Data Factory Runtime - Basic understanding of SQL Server and Azure Data Factory Books & References: Demonstration: 1. Setup SQL Server Authentication: Setup the SQL Server Authentication to SQL Server Authentication as follows. Enable Windows and SQL Server Authentication Mode Right Click on SQL Server Instance > Properties > Security > Server Authentication as SQL Server and Windows Authentication mode SQL Server Authentication Set to Windows and SQL Server Goto Security > Logins > <Username> > R

How to Upgrade Data from Microsoft Dynamics NAV to Microsoft Dynamics Business Central On Premise - Part 2

 Introduction: Now that the first step of the problem preprocessing of the NAV Database to make it ready to be migrated to BC is done(refer Part 1 ), we can now proceed further with connecting the database in Business Central On-Premise. Pre- requisites : Microsoft Dynamics 365 Business Central Microsoft Dynamics for NAV Microsoft SQL Server Management Studio (SSMS) Powershell ISE Understand NAV to BC Upgrade Considerations -  Click here Understand Upgrade Path -  Click here Books & References: Demonstration: 1. Install Business