Used for working with Microsoft SQL Server, works with both On-Premise and Azure Hosted SQL Server instances.
This connection type supports the following task types:
This connection can be used in a Data Migration.
| Usable as Source | Usable as Target | Usable as Incremental Source | Usable as Incremental Target |
|---|---|---|---|
| ✔ | ✔ | ✔ | ✔ |
| Template Name | Description |
|---|---|
| SQL Server Standard | The standard connection string for connecting to a SQL Server instance on the same server as the Agent, uses integrated SSPI security. |
| SQL Server SSAS | Uses SSAS to connect to a SQL Server instance. |
| SQL Server Trusted | Uses trusted security to connect to a SQL Server instance. This requires the agent to be running as a trusted account. |
| SQL Azure Standard | Uses the Azure standard URL naming convention to connect to SQL Server. |
The connection strings used by this connection are standard ADO.NET connection strings.
You can use Visual Studio to easily generate or find a connection string for a connected SQL Server.
We support SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL database, and Azure Synapse Analytics (formerly Azure SQL Data Warehouse).
LoadDateTime fields will be stored in UTC format in your database.
Any users who are connecting to unencrypted databases will need to add encrypt=false to their connection string as of agent version 2022.5.10.1.