SQLDBCompare

Synchronizing One SQL Object

The synchronization process is defined to synchronize two SQL objects to have same name and SQL object type. The SQLDBCompare does not allow you to synchronize two SQL objects that have different name or type.

To start synchronizing two SQL objects, you need to compare two database categories (Tables, Stored Procedures, Views or User Defined Functions) or whole databases.

To select multiple SQL objects to synchronize, you can:

Click the object that you want to include while holding down the Ctrl key.
Hold down the Shift key to click one object as the starting point then click ending object to select a block of objects.

At the Project Difference Dialog, you can highlight the SQL object that you want to synchronize, then

Select Action | Synchronize from menu of the Project Difference Dialog.
Click the Synchronize button on the tool bar of the Project Difference Dialog.
Right click the highlight bar and select Synchronize from the context menu.

Figure 1 Project Difference Dialog

The Synchronize Confirmation Dialog as shown in Figure 2 allows user confirming the selected synchronizing object(s) and choose the synchronization direction. The user can choose synchronization direction and decide if the synchronization to include all depending objects.

Figure 2 Synchronize Confirmation Dialog

If the user click the Synchronize button and there is a table object in the synchronizing object list, a Copy Table option dialog (as shown in Figure 3) will prompt you to Copy table structures and all associated properties but no records or complete table including all records.

Figure 3 Copy Table option Dialog

After clicking the Synchronize button, a column called “Complete Status” is added for displaying status of each synchronizing object. After the synchronization operation is done, the Synchronize Confirmation Dialog will be closed if no error is detected. The status of the selected object(s) in Project Difference will be displayed as same and previous selected list will be cleared. If an error is detected, the Synchronize Confirm Dialog will stay and an error message will be displayed in the Complete Status column for the SQL object that having synchronization error. The user can click the link in the “Complete Status” column to get the status of the synchronization (See Figure 5 and Figure 6.)

Figure 4 Synchronizing Confirmation Dialog With Error After Synchronization Process Is Finished

Figure 5 Synchronization Status With Error Detected

Figure 6 Synchronization Status with Succeed.