invalid column name remote_data_archive_migration_state

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 Professional. Is this issue related to the compatibility of SQL server version?


  • 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.
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.