이 블로그 검색

2014년 2월 2일 일요일

export_to_sqlite3 : simple command line based utility for exporting oracle or mysql to sqlite3

https://github.com/jeremyko/export_to_sqlite3

This is simple command line based utility for exporting oracle/mysql to sqlite3.

Usage :

export_to_sqlite SQLITE_FILE DB_TYPE DB_USER DB_PASSWD IP PORT DB_NAME

ex : from oracle 
    export_to_sqlite mydb.sqlite ORACLE  scott  tiger  192.168.1.225 1521 orcl

ex : from Mysql
     export_to_sqlite mydb.sqlite MYSQL   user  passwd   192.168.1.204 3306 PCN


auto generated scripts :

sqlite_schema_script.sql ==> sqlite table schema generation script.

sqlite_fill_script.sql           ==> sqlite table insert script.