Parameter

Description

Note

Schema1*

The schema you are comparing.

Schema2*

Schema you are comparing to.

Dbs1*

The name of the database containing Schema1

You must already have signed onto this database.

Dbs2*

The name of the database containing Schema2.

Object1

The type of object you are comparing.

This must correspond to the name of an object in the Database Explorer.

For many databases this can only be one value: Tables and Views.

For some other databases (such as Oracle), this can be one of several values such as: Tables, Views, Synonyms.

This parameter is optional. If not given, or the name supplied is not a valid object-name, the first object in the Database Explorer will be used.

Object2

The type of object you are comparing to.

If not given, the same as Object1.

Filter

A filter string for comparing a subset of the tables in the Schema.

DBName2

You would use this if the Schema you are comparing to is in a different Sybase/SQL Server database to one signed onto.

Method

The compare method.

Values:

FAST (default) or FULL.

ColMethod

When the compare method is FULL, this specifies how the columns in the tables will be compared.

Options are

• COLNO – compare by column number (default)
• NAME – compare by column name.

File*

Name of the file the Compare Schema report is written to.

FileMode

Whether the report is to APPEND to or REPLACE the contents of File.

Default is APPEND.

Report

Specifies whether the report is to include ALL tables (ALL), or just those that are different (DIFF).

Default is ALL.