Activity overview
Latest activity by heronfisher
moci wrote:
Hi I am using SQL data Compare to on a database one is dated 21 and the other is 23 Jan.
I am not able to compare a few tables so it specifies that I explicitly give a custom comparison key
a couple of my tables don't have primary keys or any other unique keys which column should i select in this case.
You need to select a column that ensures accurate comparison. The appropriate column should be a key column. If no key column exists, you must select a combination of columns.The only time you can get away with not choosing an appropriate column is if one table is empty and you are populating it. A good set of columns to use would potentially include a date column and a candidate key. / comments
moci wrote:
Hi I am using SQL data Compare to on a database one is dated 21 and the other is 23 Jan.
I am not able to compare a few tables so it specifies that I explicitly give a custom compari...