Page History

...

Anchor
ExtractDDLScripts ExtractDDLScripts

Extract DDL Scripts

To extract the DDL of the archive contents to a file

1. Open the Version tab of the archive.
2. In the Archive Contents list, right-click the object, and then select Extract DLL Scripts.
   The Extract DLL Scripts window opens.
   Image Added
3. Select the object for which you want to save scripts.
4. Select One File to save the DDL for all selected objects to one file, or select Multiple Files to save the DDL for all selected objects into single files for each object.

SQL Log

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.

SQL Errors Log

..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.

Search view

The Search view displays result values when you issue the Search command from the Main Menu.

Image Added

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.

Anchor
Search Search

Searching for database objects and synchronization scripts

...

Editors

...

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

• Click the Search icon in the Toolbar, or select Search > Search from the Main Menu.

The Search dialog contains two tabs:

• Database Search
• File Search

To search for databases

1. Navigate to the Database Search tab.
2. Use the parameter fields provided to search and locate a database:
   1. In the box on the left-hand side of the window, use the check boxes to select the Data Source Groups you want to search in.
   2. In the Search String field, type a value to search. Use the * character to indicate wildcard string values, and the ? character to indicate wildcard character values. The \ character indicates an escape character for literals. (* ? and /).
   3. Select Case Sensitive to take case into account when searching for string matches.
   4. Select Search Indexed Data to include any information that is retained by DB Change Manager’s indexing function.
   5. Select Apply SQL Filters to apply any filters you may have associated with the registered data sources in the system.
   6. Specify whether the search is limited to Declarations, References, or All Occurrences in the Limit Search to section.
   7. In the box in the lower right-hand corner of the screen, select and de-select the object types you want to include in the search. Only selected objects that match your search criteria are returned.
3. Click Search.
   DB Change Manager returns a list of all possible script selections based on the variables you entered.

To search for synchronization scripts

1. Navigate to the File Search tab.
2. Use the parameter fields provided to search and locate a synchronization script:
   1. Type a value to search in the Containing Text field. Use the * character to indicate wildcard string values, the ? character to indicate wildcard character values, and the \ character to indicate an escape character for literals. (* ? and /).
   2. Select Case Sensitive to take case into account when searching for string matches.
   3. Select Regular Expression to identify the string as a regular function in terms of search criteria.
   4. In the File Name Pattern field, specify the extension name of the files to search for explicitly. If the value in this field is a * character, the search function searches all files regardless of extension. Manually type the extensions to indicate the file type (separate multiple file types with commas), or click Choose and use the Select Types dialog to select the file extensions the process will use to search for the string. For example, selecting *.caj searches for configuration archive job files, exclusively.
   5. Select Consider Derived Resources to include derived resources in the search.
3. Click Search.
   DB Change Manager returns a list of all possible script selections based on the variables you entered

...

...

...

...

...

Configuration Archive Job Editor

...

...

...

...

...

...

...

SQL Session Options

...

1. .