Requirements for Azure SQL Database

From HVR
Jump to: navigation, search

This section describes the requirements, access privileges, and other features of HVR when using Azure SQL Database for replication. Azure SQL Database is the Platform as a Service (PaaS) database of Microsoft's Azure Cloud Platform. It is a limited version of the Microsoft SQL Server. HVR supports Azure SQL Database through its regular SQL Server driver. For information about the capabilities supported by HVR on Azure SQL Database, see Capabilities for Azure SQL Database.

For information about compatibility and supported versions of Azure SQL Database with HVR platforms, see Platform Compatibility Matrix.

Azure SQL Database
Capture Hub Integrate
Icon-Yes.png Icon-Yes.png Icon-Yes.png

Location Connection

This section lists and describes the connection details required for creating Azure SQL Database location in HVR.

SC-Hvr-Location AzureSQLDB.png
Field Description
Database Connection
Server The fully qualified domain name (FQDN) name of the Azure SQL Database server.
Database The name of the Azure SQL database.
  Example: mytestdb
User The username to connect HVR to the Azure SQL Database. The username should be appended with the separator '@' and the host name of the Server. The format is <username>@<hostname>.
  Example: hvruser@cbiz2nhmpv
Password The password of the User to connect HVR to the Azure SQL Database.
ODBC Driver The user defined (installed) ODBC driver to connect HVR to the Azure SQL Database.

Configuration Notes

  • Log-based Capture is not supported from Azure SQL. Only trigger-based capture is supported.
  • Capture parameter /ToggleFrequency must be specified because the Azure SQL database does not allow HVR's hvrevent.dll (no DLL libraries allowed). Keep in mind that if a high frequency is defined (e.g. cycle every 10 seconds) then many lines will be written to HVR's log files. Configure the command hvrmaint to purge these files.
  • When using HVR Refresh with option Create absent tables in Azure SQL database, enable the option "With Key" because Azure does not support tables without Clustered Indexes. The Azure SQL database server has a default firewall preventing incoming connections. The settings for this can be found under database server / show firewall settings. When connecting from an Azure VM (through an agent), enable Allow access to Azure services. When connecting directly from an on-premises hub, add its IP address to the allowed range. An easy way is to open the webportal from the machine you wish to connect to the database. Your IP address will be listed and by clicking on Add to the allowed IP addresses, the IP address will be automatically be added to the firewall.
SC-Azure-Azure SQL-ConfigureServer.png