This documentation is for an older version of HVR.
Capabilities
This section describes the capabilities supported by HVR on each location class.
Capture
This section lists the capabilities related to Capture.
| HVR Capability | Support 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:
|
| Log-based capture of DDL statements using action AdaptDDL | Only supported on:
|
| Log-based capture of tables without a primary key | Supported on all classes where Log-based capture (capture from DBMS logging system) is supported, except for:
|
| Direct access to logs on a file system | Only supported on:
|
| Access to logs using SQL interface | Only supported on:
|
| Log-based capture with /LogReadMethod parameter | Only supported on:
|
| Log-based capture of tables with LOB column | Only supported on:
|
| Log-based capture from hidden rowid/RRN column (ColumnProperties/CaptureFromRowId) | Only supported on: |
| Rewind log-based capture to specific time (Hvrinit option -i) | Only supported on:
|
| 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:
|
| 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:
|
| Multiple log-based capture jobs can capture from same database | Only supported on:
|
| 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:
|
| Capture from tables with advanced index compression | Only supported on:
|
| Capture from tables with advanced row compression | Only supported on:
|
| Log-based capture checkpointing (action Capture/CheckpointingFrequency) | Only supported on:
|
| Hvrlogrelease to preserve journal/archives | Only supported on:
|
| Read archives from an alternative directory (Capture/ArchiveLogPath) | Only supported on:
|
| Trigger-based capture (action Capture/TriggerBased) | Only supported on:
|
| Capture/QuickToggle | Only supported on: |
| Boundaries between transactions preserved by trigger-based capture | Only supported on:
|
| Trigger-based capture jobs can be woken by db-event when change happens | Only supported on:
|
Hub Database
This section lists the capabilities related to Hub Database.
| HVR Capability | Support Status |
|---|---|
| Hub database | Only supported on:
|
Integrate
This section lists the capabilities related to Integrate.
| HVR Capability | Support 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) | Supported on all classes where Integrate changes into location is supported, except for:
|
| Disable/enable database triggers during Integrate (/NoTriggerFiring) | Only supported on:
|
| 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:
|
| 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 Capability | Support Status |
|---|---|
| Detection of changes made by HVR in a bidirectional channel to prevent loop-back | Only supported on:
|
| CollisionDetect with Log-based Capture (without /TimestampColumn) | Only supported on: |
| CollisionDetect with Trigger-based Capture (with Capture/TriggerBased and without CollisionDetect/TimestampColumn) | Supported on all classes where Trigger-based capture (action Capture /TriggerBased) is supported, except for:
|
| CollisionDetect with /TimestampColumn | Only supported on:
|
Refresh and Compare
This section lists the capabilities related to Refresh and Compare.
| HVR Capability | Support Status |
|---|---|
| Hvrrefresh or Hvrcompare from source location | Only supported on:
|
| Select more than 4 billion rows during Hvrrefresh or Hvrcompare | Supported on all classes, except for:
|
| Hvrrefresh into target location | Supported on all classes |
| Row-wise Hvrrefresh into target location (option -g) | Supported on all classes, except for:
|
| Disable/enable foreign keys and secondary indices during Hvrrefresh (option -F) | Only supported on: |
| Disable/enable constraints check during Hvrrefresh | Only supported on:
|
| Disable/enable foreign keys from table to others during Hvrrefresh (option -F) | Only supported on:
|
| Defer foreign keys during Hvrrefresh (option -F) | Only supported on:
|
| For a table: disable/enable journaling, disable/enable unique/primary constraints, disable/enable volatile secondary indices, support main storage structure during Hvrrefresh | Only supported on: |
| Disable/enable triggers during Hvrrefresh (option -f) | Only supported on:
|
| Identity columns | Only supported on:
|
| Replicate database sequences (using action DbSequence) | Only supported on: |
| Suggestions in GUI for Slice Boundaries using DBMS statistics (Hvrrefresh option -S) | Only supported on:
|
| Select data from each table from same consistent moment in time (Hvrrefresh options -Mnow, -Mscn=val, -Mhvr_tx_seq=val, -Mtime) | Only supported on:
|
| Select data from each table from same consistent moment in time using a single transaction (and session) with 'serializable' SQL isolation level (Hvrrefresh 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 (Hvrrefresh option -Msnapshot) | Only supported on:
|
| Enable foreign keys immediately after Hvrrefresh option -Mserializable as done on -Msnapshot and -Mnow | Only supported on:
|
Other Capabilities
This section lists the capabilities related to Other Capabilities.
| HVR Capability | Support Status |
|---|---|
| Both row store and column store tables can be created | Only supported on:
|
| 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 |
| Lossless binary float datatypes. 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 as case sensitive if configured (action LocationProperties/CaseSensitiveNames defined) | Only supported on:
|
| Always treat DBMS table names and column names as case sensitive, even if not configured (action LocationProperties/CaseSensitiveNames not defined) | Only supported on:
|
| Always treat DBMS schema names case sensitive | Only supported on:
|
| Reduce width of datatype when selecting or capturing changes (action ColumnProperties/TrimDatatype) | Only supported on:
|
| Distinguish and support capture from 'materialized views' | Only supported on:
|
| Distinguish and support capture from 'row store tables' | Not supported |
| Distinguish and support capture from 'column store tables' | Only supported on:
|