Search code examples
mysqlsqliteconvertersdbmigrate

Convert MySQL database to SQLite

I have a MySQL database with some data and i want convert it to SQLite, please advise me any good tools(Windows) for it. I've tried SQLite Data Wizard, but it can't find already installed MySQL ODBC driver.

Solution

  • Since you have only 15 tables I'd suggest the most straitforward way

    1. just dump your MySQL tables using mysqldump
    2. use a good text editor to edit your files to adjust data types in table definitions and potentially data values (find & replace)
    3. use your sql script files to populate sqlite db