Select all columns as a custom comparison key

RanvirRanvir Posts: 5
edited July 16, 2015 5:50AM in SQL Data Compare 11
Hi all,

I'm a SQL DBA and have just started to use SQL Data Compare for a project I am doing.

Unfortunately the developer has not put any keys on any of the tables in the database so I'm having to go through each database and tick all of the columns to select them as comparison keys.
There doesn't seem to be any option in this tool to select all columns, you have to manually click on each one. Is there any way to speed up this process, such as scripting it out or anything else?

Thanks,

Ranvir

Comments

Sign In or Register to comment.