Capabilities for SQL Server

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on SQL Server. For more information about the requirements, access privileges, and other features of HVR when using Aurora MySQL for replication, see Requirements for SQL Server.

Capture

HVR supports the following capabilities on SQL Server:

  • Capture changes from location (SQL Server 2000 (with SP1+) and above)
  • Log-based capture (capture from DBMS logging system) (SQL Server 2005 and above)
  • Log-based capture of tables without a primary key (SQL Server 2008 and above)
  • Direct access to logs on a file system (SQL Server 2005 and above)
  • Access to logs using SQL interface (SQL Server 2005 and above)
  • Log-based capture with /LogReadMethod param (SQL Server 2005 and above)
  • Log-based capture of tables with LOB column (SQL Server 2005 and above)
  • Rewind log-based capture to specific time (hvrinit option -i) (SQL Server 2005 and above)
  • Rewind log-based capture to the beginning of currently active oldest transaction (SQL Server 2005 and above)
  • Rewind log-based capture to the beginning of currently active oldest transaction for a specific list of tables (SQL Server 2005 and above)
  • Online refresh using accurate LSN/SCN (SQL Server 2005 and above)
  • Online refresh skips capture log records early in scanner (SQL Server 2005 and above)
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (SQL Server 2005 and above)
  • Multiple log-based capture jobs can capture from same database (SQL Server 2005 and above, only FN mechanism, not SP)
  • Capture from tables with with (data_compression=row) (SQL Server 2008 and above)
  • Capture from tables with with (data_compression=page) (SQL Server 2008 and above)
  • hvrlogrelease to preserve journal/archives (SQL Server 2005 and above)
  • Read archives from an alternative directory (Capture /ArchiveLogPath) (SQL Server 2005 and above)
  • Trigger-based capture (action Capture /TriggerBased) (SQL Server 2000 (with SP1+) and above)
  • Boundaries between transactions preserved by trigger-based capture (SQL Server 2000 (with SP1+) and above)
  • Trigger-based capture jobs can be woken by db-event when change happens (SQL Server 2008 and above)


HVR does not support the following capabilities on SQL Server:

  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)
  • Log-based capture of truncate table statements
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency)


HVR Hub

HVR supports Hub database (SQL Server 2000 (with SP1+) and above)


Integrate

HVR supports the following capabilities on SQL Server:

  • Integrate changes into location (SQL Server 2000 (with SP1+) and above)
  • Integrate with /Burst (SQL Server 2000 (with SP1+) and above)
  • Integrate with /BurstCommitFrequency (SQL Server 2000 (with SP1+) and above)
  • Continuous integration (Integrate without /Burst) (SQL Server 2000 (with SP1+) and above)
  • Action TableProperties with /DuplicateRows for continuous integration (SQL Server 2000 (with SP1+) and above)
  • Continuous integrate with /OnErrorSaveFailed (without /Burst) (SQL Server 2000 (with SP1+) and above)
  • Disable/enable database triggers during integrate (/NoTriggerFiring) (SQL Server 2000 (with SP1+) and above)
  • Action Transform /SoftDelete (SQL Server 2000 (with SP1+) and above)
  • Creation and update of HVR state tables
  • Integrate with /DbProc (SQL Server 2000 (with SP1+) and above)


Bi-directional Replication

HVR supports the following capabilities on SQL Server:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back (SQL Server 2000 (with SP1+) and above)
  • Collision Detect with Trigger-based Capture (with Capture /TriggerBased and without Collision Detect /TimestampColumn) (SQL Server 2000 (with SP1+) and above)
  • Collision Detect with /TimestampColumn (SQL Server 2000 (with SP1+) and above)


HVR does not support the following capabilities on SQL Server:


Refresh and Compare

HVR supports the following capabilities on SQL Server:

  • Refresh or Compare from source location
  • Refresh into target location
  • Row-wise refresh into target location (option -g)
  • Disable/enable foreign keys from table to others during refresh (option -F)
  • Disable/enable triggers during refresh (option -f)
  • 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)
  • 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)


Other Capabilities

HVR supports the following capabilities on SQL Server:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)
  • Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc) (SQL Server 2000 (with SP1+) and above)
  • DbObjectGeneration with /IncludeSQLFile (SQL Server 2000 (with SP1+) and above)
  • International table and column names where DBMS is not configured with UTF-8 encoding