What are the challenges you face when working across database platforms? Take the survey

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

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.
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.



Sign In or Register to comment.