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
Post a Comment