HarbourBridge is a stand-alone open source tool for Cloud Spanner evaluation, using data from an existing Oracle database. This README provides details of the tool's Oracle capabilities. For general HarbourBridge information see this README.
We currently do not support dump file mode for Oracle. The only way to use HarbourBridge with OracleDB is connecting directly.
Note that 'oracle' can be used as an identifier with the flag -source in the command line.
HarbourBridge can be run directly on a Oracle database (via go's database/sql package).
The following examples assume a harbourbridge alias has been setup as described
in the Installing HarbourBridge section of the main README.
In this case, HarbourBridge connects directly to the Oracle database to
retrieve table schema and data. Set the -source=oracle and corresponding
source profile connection parameters host, port, user, dbName and
password.
For example, to perform schema conversion, run
harbourbridge schema -source=oracle -source-profile="host=<>,port=<>,user=<>,dbName=<>,password=<>"In Oracle DB, USER is the account name, SCHEMA is the set of objects owned by that user. Oracle creates the SCHEMA object as part of the CREATE USER statement and the SCHEMA has the same name as the USER.
dbName will be the SID of the Database used. The Oracle System ID (SID) is used to uniquely identify a particular database on a system.
| SQL_Server_Type | Spanner_Type |
|---|---|
| NUMBER (* , 0) | INT64 |
| FLOAT | FLOAT64 |
| BINARY_FLOAT | FLOAT64 |
| BINARY_DOUBLE | FLOAT64 |
| NUMBER (* , >0) | NUMERIC |
| CHAR | STRING(1) |
| NCHAR | STRING(N) |
| VARCHAR | STRING(MAX) |
| VARCHAR2 | STRING(MAX) |
| NVARCHAR2 | STRING(MAX) |
| CLOB | STRING(MAX) |
| NCLOB | STRING(MAX) |
| LONG | STRING(MAX) |
| ROWID | STRING(MAX) |
| UROWID | STRING(MAX) |
| DATE | DATE |
| TIMESTAMP | TIMESTAMP |
| BLOB | BYTES |
| BFILE | BYTES |
| RAW | BYTES |
| LONG RAW | BYTES |
| XMLTYPE | STRING(MAX) |
| INTERVAL YEAR | STRING(MAX) |
| INTERVAL DAY | STRING(MAX) |
| GEOMETRY | STRING(MAX) |
| JSON | JSON |