tengla / sqlite3-to-mysql Goto Github PK

A very good converter, but in order to use it, I had to include a case-independent search for AUTOINCREMENT in sed, because my "sqlite3 database.sqlite .dump" creates a dump in lowercase.

CREATE TABLE "migrations" ("id" integer not null primary key autoincrement, "migration" varchar not null, "batch" integer not null);

Added an "I" at the end.

sed \
-e '/PRAGMA.*;/ d' \
-e '/BEGIN TRANSACTION.*/ d' \
-e '/COMMIT;/ d' \
-e '/.*sqlite_sequence.*;/d' \
-e "s/ varchar/ varchar($VARCHAR)/g" \
-e "s/ integer/ int/g" \
-e 's/"/`/g' \
-e 's/CREATE TABLE \(`\w\+`\)/DROP TABLE IF EXISTS \1;\nCREATE TABLE \1/' \
-e 's/\(CREATE TABLE.*\)\(PRIMARY KEY\) \(AUTOINCREMENT\)\(.*\)\();\)/\1AUTO_INCREMENT\4, PRIMARY KEY(id)\5/I' \
-e "s/'t'/1/g" \
-e "s/'f'/0/g" \
$1

this script take the " in multiple line content into account.

http://community.kde.org/Kexi/Migration/sqlite3-to-mysql.py

The script works fine for me, but I found some string value is exceed the varchar 255 limit. Since varchar does not consume extra space for mysql, maybe you can make it a little more bigger.