Andersson HDB 1.0 Uživatelský manuál stáhnout pdf (Strana 31)

11. View the compareset:

show compareset authors_demo4

12. Create a job.

This job creates a single comparison that uses the compareset defined in step 10. It compares all rows in

the authors table:

create job authors_job4

add comparison cmp_authors4

set COMPARESET=authors_demo4

and set NUM_PARTITIONS to 1

and set ENABLE_ROW_COUNT to false

and set COMPARE_MODE to row_compare

and set HASH_TYPE to AGENT_HASH

Note

Set the HASH_TYPE comparison option to agent_hash for heterogeneous comparison. The

database_hash comparison option is used only for comparisons between Adaptive Server.

13. Execute the job to compare the data:

run job authors_job4

DA compares equivalent values stored in distinct datatypes accurately.

4.2 Support for Microsoft SQL Server

Replication Server Data Assurance Option 15.7.1 SP110 supports comparisons where the source or target

database is Microsoft SQL Server.

Supported versions:

● Microsoft SQL Server 2008

● Microsoft SQL Server 2008 R2

● Microsoft SQL Server 2012

DA does not ship the JDBC driver JAR file for a Microsoft SQL Server database. Download the JDBC type4

driver JAR file from the Microsoft Web site for your database version, and configure DA to use the JDBC driver.

New Features Guide

New Features in Replication Server Data Assurance Option 15.7.1 SP110

P U B L I C

1 2 ... 26 27 28 29 30 31 32 33 34 35 36 ... 43 44

Žádné komentáře

Andersson HDB 1.0 Uživatelský manuál Strana 31