create schema job

Creates a new schema job for comparing database object schemas.

Syntax

create 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 – creates a schema job comparison sc_job_test1 and includes all tables with some exceptions:

create schema job sc_job_test1
  set max_concurrent_comparisons = 10
  add comparison cmp1
    with source pdb0_conn s
         target rdb1_conn t1
     and target rdb2_conn t2
  include all tables
  exclude
     s.tab_x and s.tab_y

Example 2 – creates a schema job comparison sc_job_test2 and maps the source and target tables with similar names:

create schema job sc_job_test2
  set max_concurrent_comparisons = 4
  add comparison cmp1
    with source pdb0_conn s
         target rdb1_conn t1
     and target rdb2_conn t2
  map tables
        s.dbo.tab_a = t1.dbo.tab_a = t2.dbo.tab_a
    and s.dbo.tab_b = t1.dbo.tab_b = t2.dbo.tab_b
    and s.dbo.tab_c = t1.dbo.tab_c
    and s.dbo.tab_d = t2.dbo.tab_d

Usage

The include all tables clause specifies that all tables in the source database should be included for comparison, and use automatic name mapping between source database and target database tables. The exclude table clause specifies the tables you want to exclude in the source database after you have set include all tables for a schema job.
The map tables clause specifies the object mapping. A source object cannot be in the map tables and exclude tables simultaneously; the object mapping overrides the map tables clause. Object mapping for the current release is limited to tables.