• Rows can now be compared column by column. The new submenu "Compare" in the context menu of a
  row offers the comparisons below. It compares the selected rows, while the submenu "Compare"
  of the menu of a table browser and the context menu of a result tab of the SQL Console compare
  all rows. Differences are highlighted, columns present on one side only are shown as such, and
  "Only differences" hides the equal columns. The column comparison
  has a full text search (Ctrl+F) covering all rows of the overview; it selects the next row
  containing the search text when needed, and the column "Matches" of the overview shows the
  number of matches per row. The column names can be sorted. Comparisons with the rows in a
  database ("Compare with other Database...", "Compare with Current Data") can be repeated with
  "Refresh" without closing the dialog. Values are compared independent of the DBMS they have
  been read from: a date equals the timestamp at midnight of that day, a boolean equals 1 or 0,
  and trailing blanks (padding of CHAR columns) are ignored.
  For rows of a table with a primary key, the button "Synchronize..." creates a SQL script that
  makes the rows of one side equal to the other one: it inserts the missing rows and updates the
  different columns, the primary key and LOBs are left unchanged. The script can be executed
  directly, after which the comparison is repeated. For results of the SQL Console it is
  available if they are rows of a table of the data model, for "Compare with..." if both
  results are rows of the same table.
  • "Compare with Each Other" compares two selected rows of a table browser or of a result of
    the SQL Console. "Synchronize..." makes either row equal to the other one.
  • "Compare with other Database..." reads the rows having the same primary key from the database of
    another connection, for instance the target database of a subset, and compares them with
    the selected rows. The overview lists which rows are equal, which differ and which are
    missing in the other database. LOB contents are not compared. Available for tables with a
    primary key. "Synchronize..." makes the rows in the other database equal to the selected
    ones, or the other way round. Rows missing in the other database are not deleted in the
    current one: the script lists their Delete as a comment. It also creates scripts that
    repeat the changes between both databases in either direction, for instance to bring
    further databases to the same state.
  • "Compare with..." compares two results of the SQL Console. It is found in the submenu
    "Compare" of the rows of a result and in the context menu of a result tab, and lists the
    other results as "Tab : ...". The rows are paired by key columns, which are chosen
    before; the primary key columns are preselected. Rows found in one result only are listed
    as well (when comparing selected rows, only those of the other result that match a
    selected row). If a result has been cut by the row limit, the comparison says so.
  • "Compare with Current Data" compares the rows shown with the current ones, for instance to
    see the effect of an update. The rows shown are not reloaded. For a result of the SQL
    Console, the statement is executed again; changes not yet committed in the transaction of
    the SQL Console are included. Not available for explain results. For a table browser, the
    rows are read again by primary key, so rows added since are not found. Available for
    tables with a primary key. "Synchronize..." restores the rows shown, or creates a script
    that repeats the changes made since, for instance to apply them to another database.