What are the challenges you face when working across database platforms? Take the survey

ENABLE CHANGE_TRACKING causing differences

tdennistdennis Posts: 11 Bronze 2
edited November 5, 2012 2:20PM in SQL Compare Previous Versions
I'm comparing a SQL Compare snapshot of a SQL 2008 database with CHANGE_TRACKING enabled on 6 tables to a copy of the same database without CHANGE_TRACKING enabled. I've checked all the Ignore Options, but the 6 tables still appear as Different without any visible differences. Building a deployment script for the 6 tables shows a summary of "6 objects selected for deployment", Objects affected = 0 items, Copy Actions to Clipboard does nothing, and the deployment script does nothing. Is there a way to ignore the CHANGE_TRACKING discrepancy so the tables are not marked different?

Thank you,
SQL Compare


  • Options
    Unfortunately there is currently not an option to Ignore Change Tracking.
    There is an existing feature request for an Ignore Change Tracking option.
    The feature request has been assigned the internal reference number of SC-4757.
    I have added your inquiry to the existing request.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.