SQL Server

Last updated on May 30, 2023

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

This document explains the steps to add 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 SQL Server table. Read Limits on the Number of Columns.


Limitations

None.



Revision History

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

Date Release Description of Change
Apr-25-2023 2.12 Updated section, Configure MS SQL Server Connection Settings to add information that you must specify all fields to create a Pipeline.
Mar-10-2023 NA Added the privileges table in the section, Grant privileges to the database user to explain the privileges required by Hevo.
Dec-07-2022 2.03 - Added sections, Set up an SQL Server Instance, Allow Access to the SQL Server Instance, and Create a Database in the SQL Server Instance to help set up a SQL Server Destination.
- Modified the sections, Create a Database User and Grant Privileges and Configure MS SQL Server Connection Settings to add more clarity.
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.

Tell us what went wrong