Skip to main content

Posts

Showing posts with the label SQL Change Tracking

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 perio