Select all columns as a custom comparison key
Ranvir
Posts: 5
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
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
I'm afraid there is currently no way of doing this. However, once completed and the project is saved, the next time SQL Data Compare is run it will know the custom comparison keys that have been configured.
There is a user voice post here where you can vote on this feature to be implemented: https://redgate.uservoice.com/forums/14 ... ey-give-us
Kind Regards,
Nick
Redgate Support