Page 1 of 2
MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 2:52 am
by Rathinagiri
Hi,
Here is a primitive level software to convert a MySQL DB to a SQLite DB. Don't expect a perfect one!
I had added primary key only. As for as other unique and index keys, I am just working on that.
Tell me about your comments, suggestions and improvements.
For browsing SQLite database, I use
http://www.sqlitebrowser.sourceforge.net
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 3:00 am
by sudip
Hello Rathi,
Thanks a lot for this software.
Right now I don't have MySql installed in my computer
(for some technical reason). I shall install it and confirm you after testing.
Thanks again for this beautiful utility.
With best regards.
Sudip
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 9:14 am
by sudip
Rathi,
Thanks a lot. I tested it. It runs fine
Today I first tried to install MySql 5.1 but my NAV didn't allow it run
Then I tried with Easy PHP 3. Finally I can manage to run MySql. Then I tested your software.
Thanks again for the excellent utility.
With best regards.
Sudip
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 11:04 am
by Rathinagiri
Thank you Sudip for reviewing.
The application would create a .sql text file also (in SQLite syntax) in the destination directory!
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 12:17 pm
by gvaronas
Hello Rathi,
For browsing SQLite database, can test:
http://code.google.com/p/sqlite-manager/
Is very good!!!
BestRegards
GVS
P.D.: Sorry for my bad english
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 3:26 pm
by sudip
Rathi,
I was browsing the codes of your project. Excellent!
These will be very much helpful for anybody working with MySql and Sqlite.
GVS,
I downloaded Sqlite Manager (SQLiteManager_0.5.2b3.xpi). But couldn't install it.
Regards.
Sudip
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 3:58 pm
by Rathinagiri
But couldn't install it.
No. It is working fine.
Sudip, which Firefox version are you using?
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 4:02 pm
by Rathinagiri
Thanks a lot GVS. It is really good enough!
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 4:04 pm
by sudip
rathinagiri wrote:But couldn't install it.
No. It is working fine.
Sudip, which Firefox version are you using?
Ver 3.0.14. Please help me how to install this.
Regards.
Sudip
Re: MySQL 2 SQLite Converter
Posted: Sat Sep 19, 2009 4:15 pm
by Rathinagiri
Mine is 3.5.3
You can double click or use tools -> add ons -> extensions or even file -> open