Azure SQL Server

Last updated on Mar 05, 2024

Azure MS SQL Database is an intelligent, scalable, and relational database service built for the cloud. It can automate your database management and maintenance, including routine updates, backups, and security, enabling you to focus on working with your data.

You can ingest data from your Azure MS SQL database using Hevo Pipelines and replicate it to a Destination of your choice.


Limitations

  • Hevo does not support Azure CDC for replication.

  • Hevo does not fetch Views from the Azure MS SQL database automatically. As a workaround, you can create individual Pipelines in Custom SQL mode to fetch each View. However, some limitations may arise based on the type of data synchronization, the query mode, or the number of Events. Contact Hevo Support for more details.

  • Hevo does not support data replication from temporary tables.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-05-2024 2.21 Added the Data Replication section.
Jan-15-2024 NA Updated section, Limitations to add information about Hevo not supporting data replication from temporary tables.
Jan-10-2024 2.19 Updated section, Object and Query Mode Settings as per the latest Hevo functionality.
Nov-03-2023 NA Added section, Object and Query Mode Settings.
Apr-21-2023 NA Updated section, Specify Azure SQL Server Connection Settings to add a note to inform users that all loaded Events are billable for Custom SQL mode-based Pipelines.
Mar-09-2023 2.09 Updated section, Specify Azure SQL Server Connection Settings to mention about SEE MORE in the Select an Ingestion Mode section.
Dec-07-2022 2.03 Updated section, Specify Azure SQL Server Connection Settings to mention about including skipped objects post-Pipeline creation.
Dec-07-2022 2.03 Updated section, Specify Azure SQL Server Connection Settings to mention about the connectivity checker.
Apr-21-2022 1.86 Updated section, Specify Azure SQL Server Connection Settings.
Sep-08-2021 NA - Updated the third list item under Prerequisites
- Updated sub-section Grant privileges to the user.
Jul-26-2021 1.68 Added a note for the SQL Server Host field.
Jul-12-2021 NA Added section, Specify Azure MS SQL Connection Settings.
Apr-20-2021 1.61 Added the second bullet point to the Limitations section.
Mar-09-2021 1.58 Replaced references to Logical Replication with Change Tracking as Change Tracking is a distinct Pipeline mode for SQL Server Source types.
Feb-22-2021 1.57 Added sections:
- Create a Geo-replication Database
- Create a User and Grant Privileges
- Retrieve the Hostname and Port Number

Tell us what went wrong