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 |
|---|---|
| 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 | Only supported on:
|
| Log-based capture of tables without a primary key | Supported on all classes where 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 (/CaptureFromRowId) | Only supported on:
|
| Rewind log-based capture to specific time ( 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 {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 /CheckpointingFrequency) | Only supported on:
|
| to preserve journal/archives | Only supported on:
|
| Read archives from an alternative directory (/ArchiveLogPath) | Only supported on:
|
| Trigger-based capture (action /TriggerBased) | Only supported on:
|
| /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 |
|---|---|
| changes into location | Only supported on:
|
| with /Burst | Supported on all classes where is supported, except for:
|
| with /BurstCommitFrequency | Supported on all classes where is supported, except for:
|
| Continuous integration ( without /Burst) | Supported on all classes where is supported, except for:
|
| Action with /DuplicateRows for continuous integration | Supported on all classes where is supported, except for:
|
| Continuous with /OnErrorSaveFailed (without /Burst) | Supported on all classes where is supported, except for:
|
| Disable/enable database triggers during (/NoTriggerFiring) | Only supported on:
|
| Action /SoftDelete | Supported on all classes where is supported |
| Bulk load requires a staging area (/StagingDirectoryHvr) | Only supported on:
|
| Creation and update of HVR state tables | Supported on all classes, except for:
|
| 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:
|
| with Log-based Capture (without /TimestampColumn) | Only supported on:
|
| with Trigger-based Capture (with /TriggerBased and without /TimestampColumn) | Supported on all classes where is supported, except for:
|
| with /TimestampColumn | Only supported on:
|
Refresh and Compare
This section lists the capabilities related to Refresh and Compare.
| HVR Capability | Support Status |
|---|---|
| or from source location | Only supported on:
|
| Select more than 4 billion rows during or | Supported on all classes, except for:
|
| into target location | Supported on all classes |
| Row-wise into target location (option -g) | Supported on all classes, except for:
|
| Disable/enable foreign keys and secondary indices during (option -F) | Only supported on:
|
| Disable/enable constraints check during | Only supported on:
|
| Disable/enable foreign keys from table to others during (option -F) | Only supported on:
|
| Defer foreign keys during (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 | Only supported on:
|
| Disable/enable triggers during (option -f) | Only supported on:
|
| Identity columns | Only supported on:
|
| Replicate database sequences (using action ) | Only supported on:
|
| Suggestions in GUI for Slice Boundaries using DBMS statistics ( option -S) | Only supported on:
|
| Select data from each table from same consistent moment in time ( 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 ( 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 ( option -Msnapshot) | Only supported on:
|
| Enable foreign keys immediately after 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 (/DistributionKey) | Only supported on:
|
| Call database procedure dbproc during replication jobs (action /DbProc) | Only supported on:
|
| 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 /CaseSensitiveNames defined) | Only supported on:
|
| Always treat DBMS table names and column names as case sensitive, even if not configured (action /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 /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:
|
Comments
0 comments
Please sign in to leave a comment.