CODEWITHSUNDEEP
visual-studioazure-sql-database
Oyen
Oyen

Reputation: 436

How to "Ignore change tracking" in Sql Schema Compare?

Is there a way to ignore "ENABLE CHANGE_TRACKING" in SQL Schema Compare?

Upvotes: 1

Views: 707

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications. Typically, to enable applications to query for changes to data in a database and access information that is related to the changes, application developers had to implement custom change tracking mechanisms.

According my experience, we can not ignore the "ENABLE CHANGE_TRACKING" in SQL Schema Compare.

But when the the schema/database duplicated, we can disable Change Tracking manually:

ALTER DATABASE AdventureWorks2012  
SET CHANGE_TRACKING = OFF

For more details, please reference: Enable and Disable Change Tracking (SQL Server).

Hope this helps.

Upvotes: 1

Related Questions