How do I filter out tables from data compare for a sql azure managed database?

jamal

Hi, I'm comparing a local db to a version of it in an Azure sql managed instance.  Normally, when I run data compare on two databases, I can click the 'Tables & Views' tab to select only the tables I'm interested in comparing.  However, when I run the comparison above, the 'Tables & Views' tab tells me 'No data sources selected' and I am unable to filter the tables in the comparison.  If I continue, the data in every table is compared.  Is it possible to filter out (or in) the tables that are compared before the comparison runs?

Peter_Laws

Hello jamal & cas_tag,

Please could you pull down the latest update (15.0.5) that is designed to resolve this issue, and let us know if fixes your problem?

jamal

Hi @Peter_Laws - after enabling Frequent Updates, I was able to update to this version.  I can confirm this version, 15.0.5.23181, solved the issues I noted in this thread for both Sql Compare and Sql Data Compare.  Thank you!

cas_tag

Having the same issue - you used to be able to make the selection, now it doesn't seem to be an option.  Tried with multiple servers and databases and also with the latest version (v15) but same problem

cas_tag

cas_tag said:

Having the same issue - you used to be able to make the selection, now it doesn't seem to be an option.  Tried with multiple servers and databases and also with the latest version (v15) but same problem

Have raised this now with Red-Gate support, and they are investigating

jamal

Hi, glad others see it too.  Please let me know if you get anything useful from redgate support! 

cas_tag

jamal said:

Hi, glad others see it too.  Please let me know if you get anything useful from redgate support! 

Initial feedback: try different authentication methods, and also rollback to version 14.8

PBuxton

You really have to question the quality control on releases - how could this be missed?

Kurt_M

Hi all,

We are looking into this matter and our development team is working to find a solution. We will keep you all updated as soon as we have more information. In the meantime, if possible, please consider using alternative authentication methods as a temporary solution. 

Thank you for your patience.

cas_tag

cas_tag said:

jamal said:

Hi, glad others see it too.  Please let me know if you get anything useful from redgate support! 

Initial feedback: try different authentication methods, and also rollback to version 14.8

I just tried v 14.8 and same problem still (I've been offline installing a new machine)

jamal

Looks like 14.8 may have been the first version where this bug was introduced.  I'm going to try 14.7 eventually.

https://documentation.red-gate.com/sc14/release-notes-and-other-versions/sql-compare-14-7-release-notes

14.8.0.21190 - Jun 14th, 2022

FREQUENT UPDATES RELEASE

Features

• Setting an Application ID is no longer needed to connect using Azure Active Directory Universal with MFA authentication
  

cas_tag

jamal said:

Looks like 14.8 may have been the first version where this bug was introduced.  I'm going to try 14.7 eventually.

https://documentation.red-gate.com/sc14/release-notes-and-other-versions/sql-compare-14-7-release-notes

14.8.0.21190 - Jun 14th, 2022

FREQUENT UPDATES RELEASE

Features

• Setting an Application ID is no longer needed to connect using Azure Active Directory Universal with MFA authentication
  

Support told me the same thing.  They have advised though that there is a fix coming in a release possibly next week (fingers crossed)