Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
What version of SQL Data Compare are you using?
When the WHERE clause is inactive, is it grey out or in a blue colour available for use?
The data sources that you are comparing, are you comparing two live databases or a scripts folder to a database or a backup file to a database?
Senior Product Support Engineer
Redgate Software Ltd
Email: [email protected]
thank you for your reply. I run 18.104.22.16859 Professional.
The WHERE clause is grey and can't be clicked.
I compare 2 live databases.
Today I already made a lot of comparisons and the issue did not appear. I work on the same databases, and I can't say what is different compared to yesterday when I was not able to select the WHERE clause.