Standard script database variables (Oracle vs Sql Server Terminology)

Question

What are the differences/equivalences between Microsoft Sql and Oracle connection parameters, and are there some common names they map to? Things like "database", "instance", "username", "tablespace".

From Help me put Oracle terminology into SQL Server terminology we get:

| Oracle       | Sql Server    | Universal|
===========================================
| Tablespace   |               |          |
| Database     |               |          |
| Listener     |               |          |
| Instance     | Instance      |          |
| Schema       | Database      |          |
| Service Name | Database Name |          |
| SID          | Database Name |          |
-------------------------------------------

But I'm looking for a universal naming scheme that I can use in application upgrade scripts (as we need to use connection substitution parameters for both databases...).

Is Java's DatabaseMetaData a reasonable object to study?

Is the above table even appropriate? Using connection parameters, the oracle username is the schema name (yes?), and so I'd have a db.user property, and never 'db.schema`?

Answer 1

I believe the following is reasonably ok:

| Oracle        | Sql Server    | Universal|
============================================
| machine-name  | machine-name  | Server   |
| Instance      | Instance      | Instance |
| Schema (User) | Database      | Name     |
| User (Schema) | User          | User     |
| Password      | Password      | Password |
--------------------------------------------

Are there any additions anyone else can see?