Any good tools to migrate from MySQL to SQLite3?

Question

I'm struggling to find a good tool to help me migrate a MySQL database to SQLite. I've seen a couple of different Perl scripts (including one discovered here), but they do not appear to work correctly for me.

You might want to reference the tools you've tried any why they didn't meet your needs. — Paul Dixon, Jul 15 '09 at 20:19

score 6 · Answer 1 · answered Jul 15 '09 at 20:19

6

see all converters here http://www.sqlite.org/cvstrac/wiki?p=ConverterTools it has mysql converter

answered Jul 15 '09 at 20:19

Sadegh

6,654
4
34
44

Thanks for such a good reference. You saved my day! :-) – Surya Dec 27 '11 at 12:13

score 1 · Answer 2 · answered Mar 26 '13 at 16:11

1

You can try to use Data Transfer tool of Valentina Studio 5.1 to copy records of tables, from any to any of supported databases: SQLite, mySQL, postgreSQL, Valentina DB.

answered Mar 26 '13 at 16:11

Mark Robinson

11
1

score -1 · Answer 3 · answered Aug 25 '09 at 09:05

-1

I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool

Download Free : http://www.dbload.com

answered Aug 25 '09 at 09:05

The poster was asking specifically for conversion from MySQL to SQLite. However, this particular tool does not support SQLite – Raghu May 10 '11 at 20:08

Any good tools to migrate from MySQL to SQLite3?

3 Answers3