Migrate-Oracle-To-Mysql
Mirate oracle to mysql.
How to Install
- Install Instant Client Package - Basic Lite
- Install Instant Client Package - SDK
- Finally install using Node Package Manager (npm):
NPM
npm install migrate-oracle-to-mysql
GIT
git clone https://github.com/iamdenny/migrate-oracle-to-mysql.git
ENV
- It's really important. You should set up these variables
- '/opt/instantclient' is the installed directory of Oracle Client
export OCI_INCLUDE_DIR=/opt/instantclient/sdk/includeexport OCI_LIB_DIR=/opt/instantclientexport LD_LIBRARY_PATH=/opt/instantclientexport NLS_LANG=American_America.AL32UTF8
How to use
Make tables schema on Mysql same as tables schema on Oracle first.
app.js
var Mom = ;var htOracle = sHostname : '127.0.0.1' sUser : 'username' sPassword : 'password' nPort : 1527 sDatabase : 'database or sid';var htMysql = sHostname : '127.0.0.1' sUser : 'username' sPassword : 'password' nPort : 3306 sDatabase : 'database' bDebug : false;var oMom = htOracle htMysql; oMom;
Execute
node app.js