Skip to main content

Posts

Showing posts with the label BC On-premise migration to BC Online

Resolution to Cloud Migration Error - Enable Change Tracking in DB

Introduction: While I was trying to upgrade BC14 On-Premise to BC22 Saas, I noticed the following error in Cloud Migration Setup. Business Central Cloud Migration Error " Change tracking must be enabled in the source database with a recommended retention period of at least three days" This blog provides a step-by-step guide on how to resolve this issue. To know how to setup Cloud Migration follow the link -  Cloud Migration Setup Pre-requisites: Understanding of Cloud Migration Business Central v14 On-Premise Business Central Saas Subscription Books & References: https://www.olisterr.tech/2022/03/migrating-data-from-business-central-on.html https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16 Demonstration:  1. Error scenario: While setting up the Cloud migration with BC On-premise to BC Saas, I got the error  Change tracking must be enabled in the source database with a recommended retention p...

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: 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...