replace compareset

Syntax

replace compareset compareset_name
[set desc [{to|=}] description]
with source source_connection_name  owner_name 
source_table_name source_alias [where “constraint”]
target target_connection_name owner_name 
target_table_name target_alias [where “constraint”]
[and target target_connection_name owner_name 
target_table_name target_alias [where “constraint”]...] 
map {all [set strict_column=true | false] 
[set strict_type=true | false] 
[set keep_computed=true | false]
[set keep_encrypted=true | false]|
source_table_alias.column_name = target_table_alias.column_name
[ = target_table_alias.column_name ...] 
[set key=true ], 
[and source_table_alias.column_name = 
target_table_alias.column_name [ = 
target_table_alias.column_name ...] 
[set key=true]…] }

Parameters

• compareset_name – the name of the compareset to be replaced.

• description – (optional) description of the agent. Use double quotes if you are using a reserved word or blank spaces.
• source_connection_name – the name of the source connection.
• target_connection_name – the name of the target connection.
• owner_name – the name of the owner for the source or target tables.
• source_table_name – the name of the source table.
• target_table_name – the name of the target table.
• source_alias – the alias that refers to source connection, owner, and table.
• target_alias – the alias that refers to target connection, owner, and table.
• column_name – the name of the column.
• key – specifies whether the column is a primary key or an unique key.
  Note: You must define at least one key column in your compareset. When you use the map all statement, both the mapping and the key property come from the database.
• strict_column – if set to true, this parameter throws an exception if one or more source columns do not exist in target tables. By default, strict_column is false.
• strict_type – if set to true, this parameter checks the type name, scale, and precision. By default, strict_type is false.
  Note: The strict_type, strict_column, keep_computed, and keep_encrypted are used only when you use the map all statement, which requires the source and target databases to be online; while for explicit mappings, databases need not be online.

Examples

• Example 1 – replaces the current “cust1” compareset with a new compareset definition:

  replace compareset cust1 
  with source prod1 dbo_cust1 s 
       target prod1 dbo_cust1 t
  map all  
  go

Usage