Using the DEMO workspace in order to become familiar with the application

Access database objects

  1. Click on DEMO workspace name in the Resent Workspaces area
  2. Workspace with two Database Connections opened
  3. On the left side tree connect to Connection1 (double click on the connection name)
  4. On the right side tree connect to Connection2 (double clink on the connection name)
  5. Expand the trees
  6. Select any table and use tabs Table/View structure, Indexes or Primary Keys to see the tables’ metadata definition.

Compare data

Simple Example

  1. Click on the table Employees on the right tree. The table name will be highlighted.
  2. Right-click on the table Employees on the left side. From the menu select Compare->Data
  3. Table data differences dialog will open
    1. Rows with automatic font (black) are identical. See employee 3 – Leverling Janet
    2. Rows with red font are different between databases. See employee 2 – Fuller Andrew. To understand where the difference in the record is double click on it – Data Differences dialog will open. You can see that the difference is in column FirstName and values are Andrew on one side and Alex in the other.
    3. Rows with blue font – this record exists in only one of two compared tables. See employee 10 in the right side.

Advanced Example

  1. Expand Views tree node on both trees
  2. Click on Alphabetical order of products, you can see the name on the right side
  3. Right-click on Alphabetical order of products, view the name on the left side.
  4. Use Compare->Data
  5. In the comparison result window you can see rows with red colors – these rows contain different records
  6. You can see that ProductID = 2 appears on both sides but not in the same line.
    1. Why these lines are not correlated? There is no Unique Index defined in the structure, to be used as unique row identifier.
    2. How do I get correlated rows if my table/view has no unique identifier?
      1. Back to the main screen (close the dialog)
      2. Expand Alphabetical order of products tree node – you can see the columns list.
      3. Right click on column ProductID and use Order by this column
      4. You can see that the column has an icon with 123
      5. Do the same on the second tree.
      6. Compare views data anew – you can see that the result is correlated, according to the values on "ProductID" column.

Migrate structure

  • Right-click on table Products in the left side
  • From the menu select Migrate->Structure only
  • Supply new table name – this table will be created on the right side with Products structure
  • See the metadata definition. Click OK.
  • The table is created on the right side

      Synchronize

      Manual single object Synchronization

      1. Click on Order Details table on one side
      2. On the other side – right click Order Details table and use Compare->Data
      3. You can see that there are a lot of different records.
      4. Using Shift button and mouse select several red rows on left side– the selected rows will become light green colored
      5. Use the green left arrow button on the tool bar to synchronize data – the table on the right side will get data from the left side
      6. Close the dialog (commits the changes)

      Batch synchronization

      1. From the main menu select Batch Synchronization
      2. Click on the "left-to-right" arrow button on the direction area
      3. Select Order Details table pair
      4. Uncheck "Insert missing rows" check box
      5. Click "Start"
      6. Close the dialog
      7. Compare tables data anew
      8. You can see that now there are no different rows, but several rows exist only in one side (that is because you unchecked Insert missing rows)