Convert MySQL to SQlite

Question

Is it possible to convert from MySQL to SQLite with a free tool on windows?

Answer 1

Not every DB schema can be converted. MySQL is more complex and feature-rich than SQLite. However, if your schema is simple enough, you could dump it into an SQL file and try to import it / load it into an SQLite DB.

Answer 2

If you have experience write simple scripts by Perl\Python\etc, and convert MySQL to SQLite. Read data from Mysql and write it on SQLite.

Answer 3

have you tried to simply export your mysql-database and import it to sqlite? i don't know sqlite, but maybe this works that easy / maybe you have to do some little adaptations, but both is sql and should be almost compatible.

Answer 4

I don't know of a free tool, but SQLite Migrator (a product I sell) will do this for you.

http://www.logicalvue.com/products/sqlitemigrator/