Viewing Synchronization Audit

• Viewing Synchronization Details
• Exporting Synchronization Details
  

To access the Synchronization Audit details click on the top level Audit tab.

Viewing Synchronization details

DBChangeManager lists all the synchronizations done from within it by the current user in a table showing the latest ten on the top. Each synchronization listed in the table will contain the following details:

• Server: Name of the SQL Server hostname in which synchronization was done
• Database: Name of the database synchronized
• Source: The hostname and the database name of the source database based on which the destination database has been synchronized. If the source of synchronization happens to be a Snapshot or SQL Script file, information regarding the same will be presented.
• User: The DBChangeManager user login with which the synchronization was effected.
• Time - at which the synchronization was executed
• Comments: Provides a brief summary on the outcome of the synchronization done, which typically captures the status of the Synchronization done in a brief message.

You could also view the above details under the tab Sync Details at the bottom of the synchronization table, by selecting the corresponding synchronization. The success or failure status of the synchronization done would also be indicated through a corresponding icon listed at the left. Success is indicated by a Synchronization Success icon . Failure of a synchronization will be indicated by a Synchronization Failure icon.

Synchronization details - Sub-tabs:

On selecting each synchronization in the table, more details about it will be listed below in sub-tabs.

• Sync Details: All the basic information related to a synchronization will be provided under this sub-tab. These are the same information provided in the table explained above.
• Warnings: All the warnings provided by DBChangeManager to the user before the synchronization was executed will be listed under this sub-tab
• Actions: All the actions that were executed as part of the synchronization will be listed under this tab. Actions will be grouped based on the type of action and listed based on their sequence of execution in a tree format. You can collapse/expand tree nodes by clicking the    icons. Sequence of execution will also be indicated by the number displayed on the left of each action listed.
• View Sync Script: Clicking on this link will launch a new browser window in which the synchronization script that was used by DBChangeManager will be displayed. The script will be properly formatted with keyword highlighting and would be ordered by the sequence of execution.

You can save the Synchronization script by clicking on the  Save icon adjacent to each synchronization listed in the table.

Searching for Synchronization:

You can filter the synchronizations listed in the table through search boxes placed just below the headers of the table. The search does a "contains" match of the string provided. For any search string provided DBChangeManager would list all the synchronizations that contains the search string among the values present in that corresponding column. If criteria is specified in multiple search boxes then search will be performed across all the corresponding columns and list only those synchonizations which match all the criteria (AND search).

You can reset the search filter by clicking the 'Show All' link at the right-end corner of the table.

Exporting Synchronization Details

DBChangeManager provides an option to export the list of all the synchronizations done so far into an HTML document. You could do this by clicking the 'Export Result' option at the top. This will open up a new browser window which would contain the list of all synchronizations in a table as shown under the Audit option.

Note:

• Audit tab will be disabled in Free Edition of SwisSQL DBChangeManager.
• Audit tab will be enabled only for user logins with privilege to view Audit.