Competition: What’s your favorite Redgate tool? Enter now.

Select all colums as comparison key

RanvirRanvir Posts: 5
edited July 15, 2015 9:09AM in SQL Data Compare 11
Hi all,

I'm trying to do a comparison between two databases. Unfortunately the developer has not put any primary or unique keys on any of the tables so I'm having to manually add comparison keys to each table.

I want to select every column for each table as my comparison key.

However I have to click on each column to add it as a comparison key, this is taking me a long time.

Is there any quicker way to select all columns?



  • It's ok, I found out how to do this, in each table you can select all columns by doing a Select + A, which will select all columns and then click on one of the columns. This will then place a tick next to all columns.
Sign In or Register to comment.