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