Can I Still Compare the Tables When There Is No Primary Key?Yes, Datanamic DataDiff does not require a primary key. Datanamic DataDiff compares the records based on the comparison key. You can define this key. If your tables do not have a primary key then you must specify a comparison key.
To specify a comparison key for a table:
- Select the table in the list of tables in the main window.
- Click the Edit column settings button.
- In the Edit column settings dialog you see a list of mapped columns. You must tick the comparison key checkbox to add a column to the comparison key.
Datanamic DataDiff cannot compare tables when no comparison key is available.