If the source database table has no database-level primary key definition, you can define virtual indexes for the source database table to perform accurate replication.
On the
Map Tables
tab, select a mapped source table for which to add a virtual index.
Click the
Show Indexes
icon button above the source tables filter field, or right-click a mapped source table and click
Show Indexes
.
The
Indexes
dialog box appears and lists the indexes that are defined for the table.
Click
Add
.
The
Add index for table <table name>
dialog box appears.
Select the columns to use for the virtual index, or click
Select All
to select all of the columns.
You cannot edit the
Not null
setting.
In the
Index name
field, enter a name for the index or accept the default name.
Index names can contain only the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character.