Comparison Key
DBTYP.NET Studio uses table's primary key for data compare. While, primary key uniquely
identifies each row in a table, comparison of a such a tables is easy. Besides this, DBTYP.NET
allows a comparison of tables which are missing primary key definition. In such a case, you can
define virtual primary key which will not be created in a database but just inside DBTYP.NET
and it will be used as a comparison key.
Define Virtual Comparison Key
- In a grid which shows list of columns, select (highlight) row(s) which will define comparison key (virtual primary key). Note, that check boxes in a first column of rows are not used for this purpose. They are used to define which columns needs to be compared as it is described in Partial and Conditional Data Comparison
- Context mause click to bring context menu, and select Create virtual primary key
In case that primary key is missing on table and virtual comparsion key has not been defined,
DBTYP.NET Studio will show you warning as shown below:
