Capabilities

Contents

This section describes the capabilities supported by HVR on each location class.

Capture

This section lists the capabilities related to Capture.

HVR CapabilitySupport Status

Capture changes from location

Only supported on:

Log-based capture (capture from DBMS logging system)

Only supported on:

Capture from Archive log files only

Only supported on:

  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Oracle from version 9.2 to version 18.0
  • SQL Server from 2005 to 2017

Log-based capture of DDL statements using action AdaptDDL

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • DB2 for i version 7.1, since HVR 5.3.1/12
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/21
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/21
  • Oracle from version 9.2 to version 18.0
  • SQL Server from 2005 to 2017

Log-based capture of tables without a primary key

Supported on all classes where Log-based capture is supported, except for:

Direct access to logs on a file system

Supported on all classes where Log-based capture is supported, except for:

Access to logs using SQL interface

Only supported on:

Log-based capture with /LogReadMethod parameter

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0, since HVR 5.3.1/12
  • PostgreSQL from version 9.4 to version 10.0
  • SQL Server from 2005 to 2017

Log-based capture of tables with LOB column

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • DB2 for Linux, UNIX and Windows from version 9.7 to version 11.1, since HVR 5.3.1/4
  • DB2 for i version 7.1
  • DB2 for z/OS from version 11.01.00 to version 11.01.05
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 10.0 to version 18.0
  • PostgreSQL from version 9.4 to version 10.0
  • SQL Server from 2005 to 2017

Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)

Only supported on:

  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Oracle from version 9.2 to version 18.0

Rewind log-based capture to specific time (hvrinit option -i)

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • DB2 for i version 7.1
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/15
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/15
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 9.4 to version 10.0
  • SQL Server from 2005 to 2017

Rewind log-based capture to the beginning of currently active oldest transaction

Only supported on:

Rewind log-based capture to the beginning of currently active oldest transaction for a specific list of tables

Only supported on:

Online refresh using accurate LSN/SCN

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • DB2 for Linux, UNIX and Windows from version 9.7 to version 11.1
  • DB2 for i version 7.1, since HVR 5.3.1/12
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 10.0 to version 18.0
  • SQL Server from 2005 to 2017

Online refresh skips capture log records early in scanner

Only supported on:

Populates column hvr cap user for use in ColumnProperties {hvr cap user} substitutions

Only supported on:

Log-based capture of truncate table statements

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • DB2 for Linux, UNIX and Windows from version 9.7 to version 11.1
  • DB2 for i version 7.1, support depends on system setting
  • DB2 for z/OS from version 11.01.00 to version 11.01.05
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/21
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/21
  • Oracle from version 9.2 to version 18.0

Multiple log-based capture jobs can capture from same database

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • DB2 for Linux, UNIX and Windows from version 9.7 to version 11.1
  • DB2 for i version 7.1
  • DB2 for z/OS from version 11.01.00 to version 11.01.05
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 9.4 to version 10.0
  • SQL Server from 2005 to 2017, only FN mechanism, not SP

Capture from tables with basic compression

Only supported on:

Capture from tables with advanced compression

Only supported on:

Capture from tables with BLOB compression

Only supported on:

  • Oracle from version 11.2.0.4 to version 18.0

Capture from tables with advanced compression

Only supported on:

  • Oracle from version 12.2 to version 18.0

Log-based capture checkpointing (Capture /CheckpointingFrequency)

Only supported on:

hvrlogrelease to preserve journal/archives

Only supported on:

Read archives from an alternative directory (Capture /ArchiveLogPath)

Only supported on:

  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Oracle from version 10.0 to version 18.0
  • SQL Server from 2005 to 2017

Trigger-based capture (Capture /TriggerBased)

Only supported on:

Capture /QuickToggle

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

Boundaries between transactions preserved by trigger-based capture

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
  • SQL Server from 2000 (with SP1+) to 2017

Trigger-based capture jobs can be woken by db-event when change happens

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 10.0 to version 18.0
  • SQL Server from 2008 to 2017

HVR Hub

This section lists the capabilities related to HVR Hub.

HVR CapabilitySupport Status
Hub database Only supported on:

Integrate

This section lists the capabilities related to Integrate.

HVR CapabilitySupport Status

Integrate changes into location

Only supported on:

Integrate with /Burst

Supported on all classes where Integrate changes into location is supported, except for:

Integrate with /BurstCommitFrequency

Supported on all classes where Integrate changes into location is supported, except for:

Continuous integration (Integrate without /Burst)

Supported on all classes where Integrate changes into location is supported, except for:

Action TableProperties with /DuplicateRows for continuous integration

Supported on all classes where Integrate changes into location is supported, except for:

Continuous integrate with /OnErrorSaveFailed (without /Burst)

Only supported on:

Disable/enable database triggers during integrate (/NoTriggerFiring)

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • SQL Server from 2000 (with SP1+) to 2017

Action Transform /SoftDelete

Supported on all classes where Integrate changes into location is supported

Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr)

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Greenplum from version 4.0.0 to version 5.0.0
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Hive ACID version 2.1.0
  • MariaDB from version 10.0 to version 10.1
  • MySQL from version 5.6 to version 5.7
  • Redshift version 1.0
  • Snowflake version 2.8

Creation and update of HVR state tables

Supported on all classes, except for:

Integrate with /DbProc

Only supported on:

Bi-directional Replication

This section lists the capabilities related to Bi-directional Replication.

HVR CapabilitySupport Status

Detection of changes made by HVR in a bidirectional channel to prevent loop-back

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Azure SQL Database
  • DB2 for Linux, UNIX and Windows from version 9.7 to version 11.1, state table needs to be created before replication starts
  • DB2 for i version 7.1
  • DB2 for z/OS from version 10.01.00 to version 11.01.05
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03, state table needs to be created before replication starts
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 8.0 to version 10.0, state table needs to be created before replication starts
  • SQL Server from 2000 (with SP1+) to 2017

Collision Detect with Log-based Capture (without /TimestampColumn)

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

Collision Detect with Trigger-based Capture (with Capture /TriggerBased and without Collision Detect /TimestampColumn)

Supported on all classes where Trigger-based capture is supported, except for:

Collision Detect with /TimestampColumn

Supported on all classes where Integrate changes into location is supported, except for:

Refresh and Compare

This section lists the capabilities related to Refresh and Compare.

HVR CapabilitySupport Status

Refresh or Compare from source location

Only supported on:

Select more than 4 billion rows during Refresh or Compare

Supported on all classes, except for:

Refresh into target location

Supported on all classes

Row-wise refresh into target location (option -g)

Supported on all classes, except for:

Disable/enable foreign keys and secondary indices during refresh (option -F)

Only supported on:

  • Ingres from version 1.0 to version 11.0
  • Oracle from version 8.0 to version 18.0
  • Vector from version 1.0 to version 5.1

Disable/enable constraints check during refresh

Only supported on:

  • Oracle from version 8.0 to version 18.0

Disable/enable foreign keys from table to others during refresh (option -F)

Only supported on:

Defer foreign keys during refresh (option -F)

Only supported on:

  • Oracle from version 8.0 to version 18.0

For a table: disable/enable journaling, disable/enable unique/primary constraints, disable/enable volatile secondary indices, support main storage structure during refresh

Only supported on:

  • Ingres from version 1.0 to version 11.0
  • Vector from version 1.0 to version 5.1

Disable/enable triggers during refresh (option -f)

Only supported on:

Replicate database sequences (using action DbSequence)

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

Suggestions in GUI for Slice Boundaries using DBMS statistics (refresh option -S)

Only supported on:

  • Oracle from version 11.0 to version 18.0, since HVR 5.3.1/21

Select data from each table from same consistent moment in time (refresh options -Mnow-Mscn=val-Mhvr tx seq=val-M time)

Only supported on:

  • Oracle from version 8.0 to version 18.0

Select data from each table from same consistent moment in time using a single transaction (and session) with 'serializable' SQL isolation level (refresh option -Mserializable)

Only supported on:

Select data from each table from same consistent moment in time using a single transaction (and session) with 'snapshot' SQL isolation level (refresh option -Msnapshot)

Only supported on:

Enable foreign keys immediately after refresh option -Mserializable as done on -Msnapshot and -Mnow

Only supported on:

  • Oracle from version 8.0 to version 18.0

Other Capabilities

This section lists the capabilities related to Other Capabilities.

HVR CapabilitySupport Status

Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)

Only supported on:

Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc)

Only supported on:

DbObjectGeneration with /IncludeSQLFile

Only supported on:

International table and column names where DBMS is not configured with UTF-8 encoding

Supported on all classes, except for:

Lossless binary float data types. No dataloss when transporting float values (because base 2 fractions are never converted to base 10)

Only supported on:

Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames)

Only supported on:

  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Ingres from version 1.0 to version 11.0
  • MariaDB from version 5.5 to version 10.1
  • MySQL from version 5.5 to version 5.7
  • Oracle from version 8.0 to version 18.0
  • PostgreSQL from version 7.0 to version 10.0

Reduce width of data type when selecting or capturing changes (action ColumnProperties /TrimDatatype)

Only supported on:

  • Oracle from version 8.0 to version 18.0