Database question.

[Pope Viper]

Is anyone out there familiar with any tools that will convert a MySQL database into SQLite?

 

[Mord_Sith]

SQLite, sadly no, unless you decide to convert the database dump into a batch of CSV files and use native CSV import tools to load them into SQLite into pre-prepared tables.

Try searching for some tools on the web, it can't be that uncommon of a procedure.

 

[Karel]

Well, you could do it "manually" with a small script (read the data from MySQL and then store it into SQLite). Depends on the size and structure, though.

 

[Pope Viper]

I finally got a method to do it.


Found Sqlite 2008 Pro that accesses the DB directly, and then converts it to Sqlite. The thing is even free. Shock.

Thanks guys!