Azure SQL get data from another non-Azure sql server using Linked Server -


we have 2 sql server database (eg: db1 & db2) hosted in non-azure environment (dedicated server). planning migrate db1 azure sql.

is there way azure sql db1 can talk non-azure db2 using linked server approach? want query in azure sql (db1) , data of db2.

if understand correctly trying connect azure-db (db1) on-premise db (db2). on-premises sql server, can use linked servers , 4-part names point database in azure sql db using datasource - [yourazureservername@database.windows.net].[yourdatabasename].[yourschemaname].[yourtablename]

for more details please check link.


Comments