Andersson HDB 1.0 Manual do Utilizador descarregar pdf (Página 16)

1.5.1 create compareset foreach

Creates a compareset for each table after searching for all matching table names in the source and target

databases.

Syntax

create compareset [<compareset_name_prefix>] foreach table

with

source <source_connection_name> <owner_name> ["ignore_prefix

<table_name_prefix>"]

target <target_connection_name> <owner_name> ["ignore_prefix

<table_name_prefix>"]

[and target

<target_connection_name> <owner_name> ["ignore_prefix

<table_name_prefix>"]…]

[{include | exclude} <table_name_pattern> [and <table_name_pattern>]…]

[set abort_on_collision [{to|=}] {true|false}

| commit_batch_size [{to|=}] <number_of_comparesets>

| strict_all_columns [{to|=}] {true|false}

| strict_column_keys [{to|=}] {true|false}

| strict_column_types [{to|=}] {true|false}

| keep_computed_columns [{to|=}] {true|false}

| keep_encrypted_columns [{to|=}] {true|false}

[and]…]

Parameters

compareset_name_prefix

a string to prefix all compareset names.

source_connection_name

the name of the source database connection.

target_connection_name

the name of the target database connection.

owner_name

the name of the owner of the source and target tables.

table_name_prefix

a table name prefix to be ignored when matching source and target table names. The

comparison is case-insensitive. Table name prefixes do not appear in generated

compareset names. Use with ignore_prefix.

table_name_pattern

a pattern that table names must match to be included or excluded.

Options

P U B L I C

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP204

1 2 ... 11 12 13 14 15 16 17 18 19 20 21 ... 43 44

Sem comentários

Andersson HDB 1.0 Manual do Utilizador Página 16