A SQL query can be run to determine if there are any datatypes that will not be supported by Dbvisit Replicate.
Source | Target | Applicable Note № (see below) | |||||
---|---|---|---|---|---|---|---|
Oracle | Oracle 9.2 | Oracle 10+ | MS SQL Server | MySQL | Tibero | Postgres | |
NUMBER | NUMBER | NUMBER | DECIMAL or BIGINT(when scale==0) | DECIMAL or BIGINT(when scale==0) | NUMBER | SMALLINT - NUMERIC | 1, 5, 6, 7, 9 |
FLOAT | FLOAT | FLOAT | DECIMAL | DECIMAL | FLOAT | NUMERIC | 1 |
VARCHAR2 | VARCHAR2 | VARCHAR2 | VARCHAR | VARCHAR | VARCHAR2 | VARCHAR | |
VARCHAR | VARCHAR | VARCHAR | VARCHAR | VARCHAR | VARCHAR | VARCHAR | |
CHAR | CHAR | CHAR | CHAR | CHAR | CHAR | CHAR | 4 |
NCHAR | NCHAR | NCHAR | CHAR | CHAR | NCHAR | CHAR | 4 |
DATE | DATE | DATE | DATETIME | DATETIME | DATE | TIMESTAMP | |
RAW | RAW | RAW | VARBINARY | VARBINARY | RAW | BYTEA | |
LONG | x | LONG | TEXT | TEXT | LONG | TEXT | |
LONG RAW | x | LONG RAW | VARBINARY(MAX) | BLOB | LONG RAW | BYTEA | 2 |
BFILE | BFILE | BFILE | x | x | x | x | 2 |
CLOB | CLOB | CLOB | x | x | x | x | 2 |
BLOB | BLOB | BLOB | x | x | x | x | 2 |
LOB | LOB | LOB | x | x | x | x | 2 |
NCLOB | NCLOB | NCLOB | x | x | x | x | 2 |
INTERVAL | INTERVAL | INTERVAL | x | x | x | x | |
TIMESTAMP | TIMESTAMP | TIMESTAMP | DATETIME2 | TIMESTAMP | TIMESTAMP | TIMESTAMP | 3 |
BINARY_FLOAT | x | BINARY_FLOAT | x | x | x | x | |
BINARY_DOUBLE | x | BINARY_DOUBLE | x | x | x | x | |
ROWID | x | ROWID | x | x | x | x | |
XML | x | XML | x | x | x | x | 8 |
Please note the following when planning the replication.
Unsupported data types are listed here: Unsupported Datatypes
Unsupported functionality is listed here: Functionality Currently NOT Supported.
The NLS_LANG variable is set at the apply environment and behaves like the NLS_LANG environment does: it sets the language, territory and character set of the apply session. The language and territory are not very important (they affect things like Oracle error messages shown), the character set must be set to the source database character set, so the any character strings applied are treated correctly according the character set they are in. |