replace schema job

Syntax

replace schema job sc_job_name 
set max_concurrent_comparisons = 100
[and set desc [{to|=}] description]
  add comparison comparison_name
	   With source source_connection_name source_alias
   target target_connection_name target_alias
       [and target target2_connection_name target2_connection_name_alias]…
[include all tables]
         [map tables
     source_connection_name_alias.source_schema.source_object_name=
     target_connection_name_alias.target_schema.target_object_name[=
     target2_connection_name_alias.target2_schema.target2_object_name]…]
     [and source_connection_name_alias.source_object2_schema.source_object2_name=
     target_connection_name_alias.target_schema.target_object2_name[=
     target2_connection_name_alias.target2_schema.target2_object2_name]…]
     ]
          [exclude tables
     source_schema.source_object_name
     [and source_schema.source_object2_name]…]

Parameters

• sc_job_name – the name of the schema comparison job.
• comparison_name – the name of the schema comparison.
• max_concurrent_comparisons – (optional) the number of maximum concurrent comparisons. The default value is 5.
• 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.
• source_alias – the alias name of the source connection.
• target_connection_name – the name of the target connection.
• target_alias – the alias name of the target connection.
• source_schema – the schema name of the source object.
• source_object_name – the name of the source object.
• target_schema – the schema name of the target object.
• target_object_name – the name of the target object.

Examples

• Example 1 – replaces the current schema job comparison cust_sch_chk with the new definition:

  replace schema job cust_sch_chk
    set max_concurrent_comparisons 3
    add comparison chk1
      with source prod1 s
           target back1 t
      map tables
         s.dbo.cust1 = t.dbo.cust1
  go