Capabilities for Azure SQL Managed Instance

Last updated on Apr 05, 2022

Contents

This section lists the Capabilities of HVR when using 'Azure SQL Managed Instance'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Requirements for Azure SQL Managed Instance.

Capture

HVR supports the following capabilities on Azure SQL Managed Instance:

  • Capture changes from location.
  • Log-based capture (capture from DBMS logging system).
  • Log-based capture of tables without a primary key.
  • Access to logs using SQL interface.
  • Log-based capture of tables with LOB column.
  • Online refresh using accurate LSN/SCN.
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions.
  • Multiple log-based capture jobs can capture from same database.
  • Capture from tables with basic compression.
  • Capture from tables with advanced compression.

HVR does not support the following capabilities on Azure SQL Managed Instance:

  • Capture from Archive log files only.
  • Direct access to logs on a file system.
  • Log-based capture from hidden rowid/RRN column (ColumnProperties /CaptureFromRowId).
  • Rewind log-based capture to specific time (Hvrinit option -i).
  • Log-based capture of truncate table statements.
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency).
  • Hvrlogrelease to preserve journal/archives.
  • Read archives from an alternative directory (Capture /ArchiveLogPath).
  • Trigger-based capture (action Capture /TriggerBased).

Hub Database

HVR supports Hub database on Azure SQL Managed Instance.

Integrate

HVR supports the following capabilities on Azure SQL Managed Instance:

Bi-directional Replication

HVR supports the following capabilities on Azure SQL Managed Instance:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back.
  • CollisionDetect with /TimestampColumn.

HVR does not support the following capabilities on Azure SQL Managed Instance:

Refresh and Compare

HVR supports the following capabilities on Azure SQL Managed Instance:

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

Other Capabilities

HVR supports the following capabilities on Azure SQL Managed Instance:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey).
  • Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc).
  • DbObjectGeneration with /IncludeSQLFile.
  • International table and column names where DBMS is not configured with UTF-8 encoding.
  • Treat DBMS table names and columns as case sensitive if configured (action LocationProperties /CaseSensitiveNames defined) .
  • Always treat DBMS table names and column names as case sensitive, even if not configured (action LocationProperties /CaseSensitiveNames not defined) .
  • Always treat DBMS schema names case sensitive.

HVR does not support the following capabilities on Azure SQL Managed Instance:

  • Distinguish and support capture from 'materialized views'.