Chapter 11 Exercise 13

13. Use the tables for a different DBMS, or create them if necessary. Try to connect your primary DBMS to the new tables. Write a query that pulls data from both DBMSs.

Answer depends on which DBMS you start with. If you use Access, it is relatively easy to Link to SQL Server or Oracle, just choose the ODBC option and enter the appropriate database connection information. From there, queries are the same. If you are using Visual Studio, your application can connect to multiple databases. SQL Server and Oracle both support connections to databases on their like platforms. SQL Server (2005) supports linked servers in a similar manner. Find the link in Enterprise Manager under the Server Objects node. Or, use sp_addlinkedserver.