Options
Applying a WHERE clause on the source table
Torakiki
Posts: 2 New member
Hello,
seems like I can't find the option in which I can apply a WHERE clause on the source table (the source is a SQL Server database).
I'm back using SQL Data Compare after a while, and got a license for the newest version 14.*.
If I'm not mistaken, in earlier versions of the product I could right click on the table and specify a filter (for example: IDField >= 10), but now I can't find this feature; is it still available?
I'm back using SQL Data Compare after a while, and got a license for the newest version 14.*.
If I'm not mistaken, in earlier versions of the product I could right click on the table and specify a filter (for example: IDField >= 10), but now I can't find this feature; is it still available?
Tagged:
Best Answer
-
Options
PlantBasedSQL
Posts: 187 Gold 4
Hi @Torakiki thank you for your post!
The WHERE clause filtering in SQL Data Compare 14 can be found under Edit Project > Tables and Views and selecting the relevant table for the WHERE clause, as per the below:
You can also view the documentation for this here: https://documentation.red-gate.com/sdc/setting-up-the-comparison/filtering-the-comparison-with-a-where-clause
Let me know if you have any further questions - thank you very much!
Answers