What are the challenges you face when working across database platforms? Take the survey

WHERE clause inactive

I often have the problem that the link which opens the editor for the WHERE clause is inactive. Is this a known issue?


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi, thank you for your forum post.

    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?

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    Hello Eddie,
    thank you for your reply. I run 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.
    Thank you!
  • Options
    Hi .. I have the same issue .. using SQL Data Compare, I need to cop a very large SQL table from one SQL svr to another.. but the [where clause] is greyed out?
Sign In or Register to comment.