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

• 
  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 January 31, 2023 00:35

  - 0 +
• 

  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

  cas_tag January 31, 2023 12:54

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

  jamal January 31, 2023 16:52

  - 0 +
• 

  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

  cas_tag February 01, 2023 04:47

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

  PBuxton February 02, 2023 13:03

  - 0 +
• 

  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.

  Kurt_M February 07, 2023 03:16

  - 0 +
• 

  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)

  cas_tag February 13, 2023 06:41

  - 0 +
• 
  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
    

  jamal February 16, 2023 16:00

  - 0 +
• 

  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)

  cas_tag February 16, 2023 23:42

  - 0 +
• 
  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?

  Peter_Laws February 21, 2023 09:39

  - 0 +
• 
  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!
  
  

  jamal February 21, 2023 19:38

  - 0 +

Add comment

Please sign in to leave a comment.