A view is a Workbench interface component typically used to navigate a hierarchy of information or list, open editors for jobs, or display properties or settings.
Views complement editors and provide alternative presentations or navigations of the information in the Workbench. For example, Data Source Explorer provides a list of all registered data sources in DB Change Manager, organized by group folder.
Views can be active or inactive, but only one view can be active at any one time. The title of an active view is highlighted and the view is the target for common commands such as cut, copy, and paste. Views can be stacked with other views to create tabbed notebooks.
All views have two ways to access command menus:
Here are some of the ways you can interact with views:
Job Explorer provides an interface for managing existing jobs in DB Change Manager.
Use Job Explorer when searching for jobs of a specific type or name. You can list jobs according to a wide variety of categories.
To view jobs in Job Explorer
To open a job in its editor
Each time a job runs, its history is recorded and listed in the Job Explorer. You can see the history of a specific job in the job editor History tab.
Data Source Explorer lists registered data sources and the comparison jobs and archives associated with them.
When you register a new data source, you specify its connection information. Once registered, it remains stored in a catalog and does not need to be re-registered. It can be archived and used in multiple jobs.
You can organize data sources based on working sets. A working set is a user-defined collection of data sources.
To create a working set
When you select a working set, Data Source Explorer only shows those data sources you specified for the set. To change back to the default view, click the menu icon, and then choose Deselect Working Set.
To add a data source
To create Data Source Group folders and organize Data Source Explorer objects
After you import a data source, you can view and change its properties.
The name and connection properties you specified when you set up the data source are available in the Configuration pane.
To change data source properties
You can categorize data sources into the phases of the database lifecycle: Development, Test, QA, and Production. Use the Category dropdown menu to assign a category to a data source. The color coding of the category, if set, is displayed in the Data Source Explorer so you can easily differentiate the usage of multiple databases.
The Advanced tab of the Data Source Configuration properties lets you specify the JDBC or other driver properties.
Project Explorer provides a list that organizes jobs, standards, and synchronization scripts into project folders.
The list is organized by Jobs, Standards, and Sync Scripts. Double-click on the objects to open them in their editors.
A group of administrators can share a set of project files by connecting it to a source code control system and using the Navigator.
You can use the File > New > Project command to create project folders to organize and manage your jobs. When you create a new project, a folder is added to the Project Explorer with the name that you specified. You can add or delete files under this folder by dragging and dropping them from the Change Management branch.
To create a new project
The Navigator view lists all files in each of your projects. You use the Navigator to share files with a source control system for jobs, results, standards, and scripts.
Whenever a job, standard, or synchronization script is generated by the system, its output is saved to a file that is stored in a directory and displayed in the Navigator. These files can then be shared in a team environment using a source control system.
All jobs, synchronization scripts, and archive versions are stored in XML format, so that objects can be merged and differentiated between multiple versions of the same object.
Before you can use source code control, you need to install an Eclipse third-party plug- in and the appropriate client tools. |
The Compliance Explorer provides you a quick way to see comparison jobs that may have failed compliance checks.
The Compliance Explorer lists comparison jobs that have been run and specifies:
By default, jobs are not listed in the Compliance Explorer. To list a job here, select Track Results in Compliance Editor check box on the Overview tab of the specific job.
When comparison jobs run, you can optionally generate a SQL script that can synchronization the data repositories of the data sources. A synchronization script can be saved and retrieved at any time, and executed within the application.
The SQL Errors view logs any errors that may occur when executing SQL scripts.
SQL Errors are listed by SQL Error Code, SQL State, Resource, and Location.
The Data Diff view displays the values of a mismatched row pairs when viewing the results of a data comparison job. The view contains row synchronization icons and the specific data values of a selected pair.
You can specify how data is resolved in the Data Diff view by selecting one of the appropriate icons beside the Synchronization prompt. By row, you can choose to Make Target Match Source for Selected Row, Make Source Match Target for Selected Row, or Do Not Resolve Selected Row, respectively.
You can add the Data Diff View to the Workbench by selecting Window > Show View > Data Diff View.
This view lets you specify changes without resolving the repositories of both data sources with synchronization scripts.
To extract the DDL of the archive contents to a file
The SQL Log captures all SQL commands executed by SQL Editor and the system. SQL Log entries are listed by SQL Statement name, Date issued, Host/Server, Service, User, Source, and the Time (in milliseconds) it took to execute the command.
The SQL Errors log automatically logs all SQL errors encountered when SQL commands are executed through DB Change Manager. Errors are listed by Error Code, SQL State, error Details, Resource, and the Location of the error in the SQL file.
The Search view displays result values when you issue the Search command from the Main Menu.
The returned results are organized by the job type where the file resides, or by synchronization script, depending on the scope you specified. Navigate to the file that you want to open and double-click it. The file opens in a separate editor window.
In addition, the Search view toolbar provides shortcuts to preferences, a filter option when viewing results, and history commands to return or review old search results.
For more information about searching for files, see Searching for Database Objects and Synchronization Scripts.
The Search function provides a means of searching for database objects you have registered, and synchronization scripts generated by DB Change Manager.
To open the Search dialog
The Search dialog contains two tabs:
To search for databases
To search for synchronization scripts
| | | | | | | |