Working with your own Workspace

The workspace opens with trees on two sides.
  1. Double-click on one Database Connection on the left side and on other Database Connection on the right side – you are connected to your databases
  2. Expand trees and see the list of tables, views and stored procedures

Access database objects

Click on table name and use Tabs (Table/View structure, Table/View Data, Primary Keys, Indexes…) to view metadata configuration and data.

Compare data

  1. Decide which tables you want to compare
  2. Select the table name under Tables node - each table on one side
    1. Note: If your table has no unique index, select the column to be used as unique identifier, right-click on the field and select Order by this field
    2. Do it on both sides
    3. Do not forget to select the table names on both trees before you proceed to the next step.
  3. Double-click on one of these tables and select Compare->Data
  4. In the opened dialog you can see Red records for different data and Blue records for the rows, found only on one of sides.

Migrate structure

  1. Decide which table you want to migrate from one database to another.
  2. On the target database, click on Tables node
  3. On the source database, select the table you want to migrate
  4. Right-click on the table and use Migrate->Structure only
  5. You can change the table's name
  6. In the dialog with structure you can modify the target's table metadata definition

Synchronize data

  1. Decide which tables you want to synchronize
  2. Select these table names on both trees
  3. From the main menu select Synchronize->Table/View data
  4. With the arrow buttons on the dialog, select the direction from Source to Target
  5. Click OK to synchronize
  6. See the report