Client Connections

With all of the tools discussed in this chapter, you need to pass in information about the database. SQL Server has an instance name (or may be local if not named), a server, and a port. The same is true with Oracle. It has the database name (SID), server name, and port. The SID is the instance name, and a service name could be for the database, as in the case of a clustered database.

Just as with SQL Server, the clients and tools need to be able to connect to the database. You can install some sort of client on the client side or use a database driver that can accept the information needed to connect. Table 5-3 compares the connection tools available for SQL Server and Oracle.

TABLE 5-3. Client Connection Tools

Several different ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.