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.
댓글 없음:
댓글 쓰기