Setting default key comparison as all columns if primary key is not present

Abdu

I have a database with hundreds of tables many of which don't have a primary key. It seems SQL Data compare doesn't include these in the deployment and I have to manually set up the comparison key for each table which is time consuming.
All the destination tables are empty. I would like it if there's an option that if the destination table is empty to just copy the data. There's no need to have comparison keys identified.
OR
Have some setting where I can set it to use all the columns as the comparison keys. If I want to change the default for a table on demand, I can as well.

Jessica R

Hi @Abdu,

Thanks for your suggestion!

Can you please post this idea on our Uservoice forum here: https://redgate.uservoice.com/forums/147879-sql-data-compare/

Our developers monitor this forum and use it as an important resource when deciding new features.