jeremyko

Tags

oracle, mysql 을 sqlite3로 export 하기

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

from oracle

export_to_sqlite mydb.sqlite ORACLE scott tiger 192.168.1.225 1521 orcl

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.