Tech Community link: techcommunity.... Clean up the resources in order: DROP EXTERNAL TABLE [dbo].[Tablename] DROP EXTERNAL DATA SOURCE [Databasename] DROP DATABASE SCOPED CREDENTIAL CREDENTIAlname DROP MASTER KEY
Пікірлер: 6
@SameerSK52 Жыл бұрын
IMO It will be easier to switch over to oracle and use db links than wasting time setting up external tables and getting super slow performance
@MSSQLDBATechSupport Жыл бұрын
i am not sure about dblinks.however external queries are not slow
@theunitedvlog012 жыл бұрын
this is a great video. what about when you have two servers and want to query across these databases in different server?
@MSSQLDBATechSupport2 жыл бұрын
The same way how we can do in same server. Thanks Admin
@bhanuprakash84002 жыл бұрын
Suppose Origina Azure SQL Single DB and Remote is Azure SQL VM DB. Can we use this Elastic queries? However we can create linked sever from Azure SQL VM to Azure SQL Single db. Please suggest.
@MSSQLDBATechSupport Жыл бұрын
Yes.U can create Linked server from Azure VM SQL Server to Azure sql single DB.