Andersson HDB 1.0 Bedienungsanleitung PDF herunterladen (Seite 19)

Example 4

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

prefix, including tables only with names that begin with the prefix "customer_" or "cust_". Each target

table must contain all the source table columns with the same name, type, precision, and scale:

create compareset foreach table

with source conn_venus dbo

target conn_pluto dbo

and target conn_earth dbo

include customer_*

and cust_*

set strict_all_columns true

and set strict_column_types true

Example 5

Creates a compareset using tables whose names begin with "abc" in the source, conn_venus, and the

target, conn_pluto—but ignores the table name prefix copy_of_. For example, if the source includes table

abcdef and the target includes table copy_of_abcdef, this command uses the two tables to create

compareset cs_abcdef.

create compareset cs_ foreach table

with source conn_venus dbo

target conn_pluto dbo "ignore_prefix copy_of_"

include abc*

Usage

● When overriding the default compareset prefix:

○ The compareset name prefix cannot begin with a digit.

○ Do not create unnecessary duplicate comparesets.

Note

DA creates duplicate comparesets if you run create compareset foreach multiple times with

different prefixes.

● The prefix that might be present in a target table name is different from the prefix you can set on

compareset names.

● You can use wildcards in the <table_name_pattern>. For example:

○ include a* and b* – includes all table names beginning with a or b only.

○ exclude *_???– excludes all table names that end with an underscore followed by any three

characters, such as table_001 and table_002.

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP204

P U B L I C

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

Keine Kommentare

Andersson HDB 1.0 Bedienungsanleitung Seite 19