olisterr.tech | Blog on Dynamics 365 Business Apps, NAV / Business Central, Power Platform and Azure

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: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-data 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