Options

Compare Data Options

Compare interval refresh time: Time interval in seconds to refresh the compare progress in terms of row count. Default is 2.
Maximum number of failures: Stops the compare when the specified number of failures (non-matching rows) is reached. Default is 50.

HCOSS Connections

Automatically Test Connections

`True`	HCOSS automatically tests your established database connections and automatically updates their status. Default.
`False`	You must update the status of each connection using the Refresh button in the Manage Connections tool.

Data source to use for testing DLL

The name of the SQL Server connection you want to set as the default testing database when generating DDL. If you do not provide a SQL Server connection, HCOSS does not perform any tests when generating DLL. (optional)

Name of the current/default target data source

The name of the SQL Server connection that you want to set as the default connection. (optional)

Timeout value for each connection

When checking a connection status, the number of seconds HCOSS waits for a returned status before moving on to check the next connection listed on the Connection List tab of the Manage Connections tool. Applies only to the Connection List tab. The default is 5.

HCOSS Directories

Local HCOSS Directory

The parent directory to the subdirectory structure used to store local generated HCOSS files. The default is %LOCALAPPDATA%\Micro Focus\Enterprise Developer\hcoss\genFileType.

Where genFileType is one of the following:

ApplicationAssessments
CompareTasks
DataTasks
DBRMDataSets
DDLTasks
Schemas
TargetLists

Shared HCOSS Directory

The parent directory to the subdirectory structure used to store shared generated HCOSS files. The default is %LOCALAPPDATA%\Micro Focus\Enterprise Developer\hcoss\genFileType.

Where genFileType is one of the following:

ApplicationAssessments
CompareTasks
DataTasks
DBRMDataSets
DDLTasks
Schemas
TargetLists

Note: All users must have READ/WRITE access to this directory.

HCOSS UAC Behavior

Prompt to automatically run as Administrator

`True`	When you start HCO for SQL Server as a standard user from the Start menu, and you are a member of the Administrators group, HCOSS prompts you to run HCOSS as an Administrator. Default.
`False`	HCOSS does not prompt you to run HCOSS as an administrator.

Run as Administrator if in Administrators Group

`True`	When you start HCO for SQL Server as a standard user from the Start menu, and you are a member of the Administrators group, HCOSS automatically runs in administrator mode. At startup, a Windows UAC prompt appears.
`False`	HCOSS does not automatically run HCOSS as an administrator, but prompts you to start as an administrator when you launch HCOSS from the Start menu as a standard user. Default.

Warn non-Administrator users of limited functionality

`True`	When running HCOSS as a standard user, HCOSS presents this prompt at startup to warn you that some functionality is limited when running in standard user mode. Default.
`False`	HCOSS presents a prompt at startup to warn you of limited functionality.

Log File Options

Automatically delete log files

Enable or disable the automatic deletion of log files older than the number of days specified by the Days before automatically deleting log files option. The default is False.

Days before automatically deleting log files

The number of days to wait before automatically deleting log files. Valid when Automatically delete log files is set to True. The default is 30.

Directory to write log files to

The parent directory to the subdirectory structure used to store HCOSS-generated log files. The default is %LOCALAPPDATA%\Micro Focus\Enterprise Developer\hcoss\genFileType.

Where logFileType is one of the following:

BindTasks
CompareTasks
Connections
DataTasks
DDLTasks
Schemas
TargetLists

Note: HCOSS does not create log files when Type of logging to do is set to Write log messages just to console, which is the default setting.

Type of logging to do

Set HCOSS to send log information to the console, a log file, or both. Default is Write log messages just to console.

Startup

HCOToolStartup: Specify the type of HCO for SQL Server startup environment, whether to start by loading information from the last session or to start with no previous information loaded. Default is Show empty environment.