CODEWITHSUNDEEP
mysqlsqliteconvertersdbmigrate
whizzzkey
whizzzkey

Reputation: 946

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.

Upvotes: 1

Views: 1689

Answers (1)

peterm
peterm

Reputation: 92785

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

Upvotes: 1

Related Questions