invalid column name remote_data_archive_migration_state

chippychippy Posts: 1 New member
in SQL Compare
I am getting an error like this  " invalid column name remote_data_archive_migration_state" while trying to compare two databases. I am using SQL Compare 11.4.3.26 Professional. Is this issue related to the compatibility of SQL server version?
Tagged:
· Share on Twitter

Answers

  • Sergio RSergio R Posts: 610 Rose Gold 5
    Yes, that's due to a feature introduced in SQL Server 2016 and that version of SQL Compare does not support SQL Server 2016.
    The latest version of SQL Compare 11 (11.6.11) will not have this issue. However, if you are able to do som I would advise you to download the very latest version instead (14.0.3), so that you benefit from updated features and more bug fixes.
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
Sign In or Register to comment.