You can choose Data Comparer or Database Comparer to compare and synchronize two database tables.
Step 1: Open SQL Server Comparison Expert, click "Connection" button, then the connection dialog pops up.
Step 2: Click "Option" to open the Project Option, you can select the Object Types (Tables) to compare. Click "OK" to continue.
Step 3: Then click "OK" to finish the connection. Click "Compare" to contrast two database tables structures.
Step 4: If there are differences, you can click "Sync" to synchronize database table structure.
Step 5: Click on "Data Result", then click "Choose" to select a data table to contrast (dbo.data_compare).
" button. If there is no primary key
, you can select "id
" or "data_Added
" columns by clicking the check-box in the popup dialog. Then click "OK
" to continue. If the primary key
already exists, it will skip to choose unique. Then you can compare directly.
Note: When the Unique Columns is null, click "...", you can choose some or all columns as Unique Columns in the pop-up box.
Step 7: Click "Compare" button, the result of contrast will show you below.
Step 8: Click "Sync" to synchronize the data. The following is the data synchronization process.
Step 9: Click "Compare" button to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed.