How do I filter out tables from data compare for a sql azure managed database?
jamal Posts: 46 Bronze 3
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 Posts: 101 Bronze 5Hello 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?Kind regardsPeter Laws | Redgate SoftwareHave you visited our Help Center?
jamal Posts: 46 Bronze 3Hi @Peter_Laws - after enabling Frequent Updates, I was able to update to this version. I can confirm this version, 18.104.22.16881, solved the issues I noted in this thread for both Sql Compare and Sql Data Compare. Thank you!
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.
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
22.214.171.12490 - Jun 14th, 2022
FREQUENT UPDATES RELEASE