The other database can be SQL Server, Oracle or another supported database: we could use linked servers to establish connections to a set of source systems available on a datawarehouse/BI environment or multiple databases. In Oracle environments this functionality is called DBLinks (Database Links).Īs a quick example, we can consider a scenario where we need to create a view (saved query) on a database which receives data from a database that resides on a remote server. In this way you can write SQL queries or stored procedures from SSMS directly on a remote database on another machine. ![]() In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |