Microsoft SQL Server

Hevo can load data from any of your Pipelines into a Microsoft SQL Server database.

In this document, we will walk through the steps to add Microsoft SQL Server as a Destination.

Destination Considerations

  • You must disable any foreign keys defined in the target tables. Foreign keys do not allow data to be loaded until the reference table has a corresponding key defined.

  • You can replicate data for only 1018 columns in a given MS SQL Server table. Read Limits on the Number of Columns.



Revision History

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

Date Release Description of Change
Sep-07-2022 NA - Updated the Prerequisites section and added the Create a Database User and Grant Privileges section.
- Updated the Configure MS SQL Server Connection Settings to add a link to the Connecting to a Local Database page.
- Deleted the Connect to a Local Database section.
Jul-26-2021 1.68 Added section, Connect to a Local Database.
Jul-12-2021 NA Updated the section, Destination Considerations.
Last updated on 28 Oct 2022

Tell us what went wrong