Page History
...
| Anchor | ||||
|---|---|---|---|---|
|
The Refinements Options determine whether new objects are included. By default, they are included when you run a schema comparison job. You can configure the job to ignore new objects by unchecking this option.
Command Line
...
Compliance
...
Label Decorations
...
...
You can specify the Default Script Output for the following command line jobs:
- Windows (*.bat). By default, the command line interface produces batch files.
- Ant (*.xml). Click Ant (*.xml) if you want the command line interface to produce XML files by default.
Once you configure new defaults, click Apply. For more information, see Generating Command Line Scripts.
Compliance
You can specify default compliance ranges for comparison results. These ranges are percentage amounts that specify when to pass, warn, or fail a configuration comparison job in the Compliance Explorer.
These options include:
- Compliance Met. By default, this value is 100%, which allows a job to pass.
- Compliance Critical. By default, this value is 75, meaning that 75-99% compliance results in a warning.
- Compliance Not Met. By default, this value is 0, meaning that 0-74% compliance results in a failure.
Once you configure new defaults, click Apply.
Label Decorations
Label Decorations provides a link to the standard Eclipse Preferences section where you can specify decorations for an object in the Eclipse interface.
In the Job Decoration Text panel, select Project to add a decoration in the Project Explorer.
Once you configure new defaults, click Apply.
| Anchor | ||||
|---|---|---|---|---|
|
You can specify email server parameters that enable email notifications for jobs.
The parameters include:
- Host. The name of the email host server is required.
- Port. The default port number is 25.
- Sender Address. The email address to use for sending email from DB Change Manager to others.
- User Name. The user name of the sender on the mail server.
- Password. The password of the sender on the mail server.
- Web Server Report Directory. The root directory of the web server where DB Change Manager saves reports; for example, c:\apache2\htdocs.
- Web URL Prefix. The URL used by DB Change Manager to specify links in the report and in the notification email; for example, http://www.webserver.com/.
Use the Test Email button to validate the settings. DB Change Manager prompts you for an email address, and then sends a test notification email to that address.
Once you have validated the email settings, click Apply.
Notification > Email Notification > Advance Settings
Advanced Settings lets you map SMTP properties to values. Refer to https://javaee.github.io/javamail/FAQ for more information.
SMTP properties are listed at: http://https://javaee.github.io/javamail/docs/api/com/sun/mail/smtp/package-summary.html.
Notification > Email Notification > Contacts
Contacts are email addresses used in email notifications. When a new notification is sent, it is sent to all of the addresses added to the contact list.
To add a contact
- In Preferences > Notification > Email Notification > Contacts, click Add.
- Enter an email address, and then click OK.
You can also import existing contact lists from XML files, or export the current contact list as an XML file.
Notification > Email Notification > Templates
You can create and edit email templates that format the texts used in email notifications. The default template shows how the templates work. You can add a template and customize the values of the template variables.
Available actions include:
Edit. The Edit button opens the Edit Template dialog for the selected template.
Info Press Ctrl-Space on the Notification screen to open a list of variables.
- Add. Opens the Add Template dialog.
- Remove. Removes the selected template.
To create a new email notification template
- Select the default template.
- Click Edit.
- Click the Template Key icon on the left to see the template variables that are available.
- In the Body section, select and copy the template text.
- Click Cancel.
- In Preferences > Templates, click Add.
- In the Add a Template dialog Body section, paste the copied text.
- Edit the text. Click the Insert template key dropdown to select from a list of variables.
- Name the template.
- Type the Subject content that is the subject of your email. You can use variables in a subject.
Notification > File System Notifier
You can specify where file system notifications are stored using Preferences > Notification > File System Notifier options, including:
- Enable file system notification service. By default, file system notifications are not enabled. Select this option to enable them.
- Report, Log, and Script Directories. By default, file system notifications are created in the Documents and Settings/username/ Change Manager Results directory. Click Browse to change the default directories.
Once you have validated the email settings, click Apply.
Notification > Popup Notification
You can set the default options for System Tray notifications, including:
- Enable system tray notification service. By default, system tray notifications are not enabled. Select this option to enable them.
- Display notification time. By default, the notification lasts for 3000 milliseconds.
- Show only when minimized to tray. By default, the popup displays when the System Tray is minimized.
- Play sound. By default, if notifications are enabled, a sound accompanies a notification.
- Custom sound. You can change the default sound and select a .wav sound file.
Once you have validated the email settings, click Apply.
Notification > Popup Notification > Advanced Settings
You can change the default options for System Tray notifications. These options include:
- Generate notification when job is run from. By default, if notifications are enabled, a notification is generated for each job run from the Workbench or from the command line. You can limit notifications to one or the other.
- Generate notification when job finishes. By default, a notification is generated for each job that succeeds or fails. You can limit notifications to one or the other.
- Generate notification for threshold. This option is currently unavailable.
After you change the notification settings, click Apply.
Projects
The Projects option applies to the Project Explorer:
- Suppress Project Required Warning Dialog. This option disables the warning dialog when using the Project Explorer. By default, it is disabled.
After you change the projects settings, click Apply.
| Anchor | ||||
|---|---|---|---|---|
|
The Reports settings let you customize the look, feel, and format of reports issued when you generate a job report for comparison jobs.
- The Report Style tab
- Logo. You can browse to upload a logo. The logo should be 80 pixels wide by up to 420 pixels tall.
- Accent color. You can select an accent color from the color palette.
After you change the style settings, click Apply.
- The Paper Setup tab
- Paper size. You can use the dropdown list to select from a list of standard paper sizes, and choose between Portrait or Landscape orientations.
- Margins. You can set the Top, Right, Left, and Bottom margins for the paper. If you prefer not to use inches, set the Unit option to either centimeters or millimeters.
After you change the paper setup options, click Apply.
- The Contents tab
- CM/Config: Include matching configuration parameters. By default, matching configuration parameters are included in a report.
- CM/Data: Include matching data fields (database level). By default, matching data fields in databases are included in a report.
- CM/Data: Include matching data fields (table level). By default, matching data fields in tables are included in a report. You cannot change this option.
- CM/Data: Include detail reports in CM/Data notifiers. By default, details are included in a data job notification.
- CM/Schema: Include matching schema objects. By default, matching schema objects are included in a report.
- CM/Schema: Include DDL in Schema Reports. By default, DDL is included in a report. If you do not need the DDL in the report, and to improve performance, deselect this option.
- Split reports when exceeding _ number of objects. By default, reports including over 1000 objects are split into multiple sections, to improve performance. You can change the default number of objects in a section.
After you change the contents options, click Apply.
- The Font tab
- Path. By default, DB Change Manager includes the FreeSerif.ttf font for use in reports. You can change this to another font on your system.
- PDF Encoding. If you change the font, make sure that the appropriate PDF encoding is set. Leave the field blank to use the default encoding.
After you change the font options, click Apply.
Script Execution Options
The Script Execution Options apply to automation scripts:
- Connection Auto Commit. By default, auto commit applies to synchronization scripts for data comparison jobs.
If you change the script execution settings, click Apply.
System Tray
The System Tray options affect the Windows System Tray:
- Show System Tray Icon. By default, the System Tray icon is shown.
- Minimize to System Tray. You can minimize the system tray by selecting this option.
If you change the System Tray settings, click Apply.
Task Scheduler
The Task Scheduler options affect batch files:
- Always schedule auto generated batch files. By default, automatically generated batch files do not run on schedule. Select this option to require scheduling.
- Batch files directory. By default, batch files are saved in Documents and Settings\username\change_manager_x\workspace\Change Management\AutoGeneratedBatchFiles. You can change this to another directory.
If you change the task scheduler settings, click Apply.
Data Sources
The Data Sources preferences specify where registered data source definitions and metadata are stored:
- Data Sources. By default, batch files are saved in Documents and Settings\username\Application Data\IDERA\Data Sources. You can change this to another directory.
- Metadata. By default, metadata files are saved in Documents and Settings\username\Application Data\IDERA\Data Sources\metadata. You can change this to another directory.
If you change the data source file location settings, click Apply
...
...
...