show compareset

Shows zero or more comparesets, which includes the database connection profile, the tables that are compared, and the column mappings.

Syntax

show compareset [compareset_name[columns]]

Parameters

compareset_name – (Optional) the name of the compareset to be shown.

Examples

Example 1 – shows the compareset “cust_orders” :

show compareset cust_orders
go

The returned result is:

 TYPE CONNECTION OWNER TABLE        WHERE CONSTRAINT
 ---- ---------- ----- ------------ ----------------
 S    conn_prod  dbo   cust_orders
 T    conn_bak1  dbo   cust_orders
 T    conn_bak2  dbo   cust_orders
 
(0 rows affected)

Example 2 – shows all the comparesets :

show compareset
go

The returned result is:

NAME            DESCRIPTION
----            -----------
cust            The customer tables.
cust_orders     The customer orders tables.

Example 3 – shows the column mappings in compareset “cust_orders”’:

show compareset cust_orders columns
go

The returned result is:

TYPE  CONN       TABLE        MAP_ID  COL_NAME     COL_TYPE      P_KEY
----  ---------  -----------  ------  ----------   -----------   -----
 S    conn_prod  cust_orders       1    id         numeric(11)     Y
 T    conn_bak1  cust_orders       1    id         numeric(11)     Y
 T    conn_bak2  cust_orders       1    id         numeric(11)     Y
 S    conn_prod  cust_orders       2    cust_id    numeric(9)      N
 T    conn_bak1  cust_orders       2    cust_id    numeric(9)      N
 T    conn_bak2  cust_orders       2    cust_id    numeric(9)      N
 S    conn_prod  cust_orders       3    sku        varchar(50)     N
 T    conn_bak1  cust_orders       3    sku        varchar(50)     N
 T    conn_bak2  cust_orders       3    sku        varchar(50)     N
 S    conn_prod  cust_orders       4    date       datetime        N  
 T    conn_bak1  cust_orders       4    date       datetime        N 
 T    conn_bak2  cust_orders       4    date       datetime        N