This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
We are thinking of moving our on prem NAV SQL Server into Azure but if this does happen our BI SQL Server 2016 will not move at the same time. The SSIS jobs on the BI Server will still need to select data out every hour. (BI into Azure or SSIS setup in ADF possibly will be done at a later date).
What are the recommended ways to connect an on-prem SQL Server 2016 to Azure SQL, from my research so far it looks like we could simply create a new Linked Server to Azure.
If anyone has any good links that can further my research, thoughts and possible pitfalls if you have done this setup previously, these would be most welcome.
thanks,
Jay
You can use SSIS to connect directly to the Azure SQL database, that's fully supported, see https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15