Andersson HDB 1.0 Manual de usuario descargar pdf (Pagina 18)

Parameter Value

keep_computed_columns Whether to include computed columns in the compareset column

mappings.

Valid values: true or false

Default: false

keep_encrypted_columns Whether to include encrypted columns in the compareset column

mappings.

Valid values: true or false

Default: false

Examples

Example 1

Creates a compareset for each table that exists in both the source and target databases for DA

connections "conn_venus" and "conn_pluto" respectively. Each compareset name uses the default

prefix:

create compareset foreach table

with source conn_venus dbo

target conn_pluto dbo

Example 2

Creates a compareset for each table that exists in both the source and target databases using the prefix

"cmpset_", excluding the SAP Replication Server tables, which have names that are prefixed with "rs_":

create compareset cmpset_ foreach table

with source conn_venus dbo

target conn_pluto dbo

exclude rs_*

Example 3

Creates a compareset for each table that exists in both the source and target databases using the prefix

"cmpset_" excluding SAP Replication Server tables. The command does not abort if a compareset is

generated with the same name as one that already exists and buffered comparesets are committed to the

DASD in batches of 100:

create compareset cmpset_ foreach table

with source conn_venus dbo

target conn_pluto dbo

exclude rs_*

set abort_on_collision false

and set commit_batch_size 100

P U B L I C

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP204

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 ... 43 44

Sin comentarios

Andersson HDB 1.0 Manual de usuario Pagina 18