0

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.

MPelletier
  • 16,256
  • 15
  • 86
  • 137
whizzzkey
  • 926
  • 3
  • 21
  • 52
  • Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it. –  Jan 09 '14 at 04:47
  • @MikeW i already have described my problem - for this operation i'v used a SQLLite Data Wizard, but when i've tried to configure the connection, it can't see MYSQL ODBC Driver, it offered only MSSQL drivers, and even i've reinstalled MySQL ODBC Drivers it still found nothing. – whizzzkey Jan 09 '14 at 04:53
  • How many tables in your database? – peterm Jan 09 '14 at 05:10

1 Answers1

1

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
peterm
  • 91,357
  • 15
  • 148
  • 157