From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Linked server database models

Linked server database models - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Linked server database models

“

- [Male Announcer] Not all of the information needed for the design of an application has to be stored within a single instance of of SQL Server. Through a feature called Linked Servers. SQL Server's database engine can query tables and other remote instances of SQL Server or even other products. Such as Microsoft Access Databases, Oracle Databases, Excel Spreadsheets and even plain text files. To link servers together the external data source must have a registered OLE DB provider on the computer running the main instance of SQL Server. OLE DB stands for Object Linking and Embedding for Databases. And are supplied by the source applications vendor. The OLE DB provider is a DLL library file that provides SQL Server with the connection information that it needs to locate and utilize the remote sources. Some data providers allow read only access. While others allow full manipulation of the data. Including performing updates and deletes. By linking servers together you can gain access to…

Contents