Azure SQL Server

Last updated on Dec 28, 2022

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.


Revision History

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

Date Release Description of Change
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