Capabilities for Azure SQL Data Warehouse

From HVR
Jump to: navigation, search

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

Capture

HVR does not support Capture changes from location on Azure SQL Data Warehouse


HVR Hub

HVR does not support Hub database on Azure SQL Data Warehouse


Integrate

HVR supports the following capabilities on Azure SQL Data Warehouse:


HVR does not support the following capabilities on Azure SQL Data Warehouse:

  • Action TableProperties with /DuplicateRows for continuous integration
  • Continuous integrate with /OnErrorSaveFailed (without /Burst)
  • Disable/enable database triggers during integrate (/NoTriggerFiring)
  • Integrate with /DbProc


Bi-directional Replication

HVR does not support Bi-directional Replication on Azure SQL Data Warehouse


Refresh and Compare

HVR supports the following capabilities on Azure SQL Data Warehouse:


Other Capabilities

HVR supports the following capabilities on Azure SQL Data Warehouse:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)
  • International table and column names where DBMS is not configured with UTF-8 encoding