WHERE clause inactive

RalfWestphal · September 14, 2020 2:16PM

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

Eddie D · September 15, 2020 5:50PM

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

RalfWestphal · September 16, 2020 8:15AM

Hello Eddie,
thank you for your reply. I run 14.3.3.16559 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!

HTC_user_123 · February 4, 2023 9:53AM

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?

Dar · October 13, 2024 6:34PM

What's Up?.....Same issue in version 14.7.8.21163 Professional. Although it seems to come and go! Dar -DA

WHERE clause inactive

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk