How do I filter out tables from data compare for a sql azure managed database?
jamal
Posts: 47 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?
James
Tagged:
Best Answers
-
Peter_Laws Posts: 287 Silver 2
-
jamal Posts: 47 Bronze 3Hi @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!
James
Answers
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.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
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