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.

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

At the synchronizing process, a column called “Complete Status” is added for displaying all synchronization status of each synchronizing object. If no error is detected, after the synchronization operation is done on all selected SQL object(s), the Synchronize Confirmation Dialog will be closed. The status of the selected object(s) in Project Difference will be displayed as same and the highlighted selection list will be cleared. If an error is detected, the Synchronize Confirm Dialog stays and an error message will be displayed in the Complete Status column for the SQL object that having synchronization error. The users can examine the error message on the window and re-do the synchronization at later time.

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