Database choice - converting sqlite to mysql

peramangk · Post by **peramangk** » Fri Jul 03, 2009 7:06 am

I'm puzzled.

I chose sqlite as my database platform because I wanted ease of distribution if I created a standalone. Sqlite is 'built-in' to Revolution and would not require a messy installation for a user (of unknown competency).

I've already spent a lot of time on the database and its Revolution front end.

Now I also want to put the database on on-rev which appears to favour MySQL.

Do I have to completely rebuild the database?

... or is there an easier option?

Mark · Post by **Mark** » Fri Jul 03, 2009 9:34 am

Hi peramangk,

If you're on windows, you can use the command line utility, which you can find here to execute the .dump command and create a sql file of your sqlite database. You should be able to import this sql file into your MySQL database.

If you are on Mac OS X, you can use the sqlite3 command from the terminal. I expect this to work in Linux as well. If not, you might download a command line utility for Linux at aforementioned page.

Best regards,

Mark

dmsoft · Post by **dmsoft** » Sat Jul 04, 2009 7:45 pm

Hello,

You can try http://www.dbconvert.com/convert-sqlite ... .php?DB=10

Regards,
Dmitry

Mark · Post by **Mark** » Sat Jul 04, 2009 7:53 pm

Keep in mind that Dmitry's product costs 79 dollar, while a simple dump-and-import is free. No doubt, this product may be helpful for migrating large and complex databases, but I'm pretty sure that peramangk's isn't of such a magnitude and compexity.

Best,

Mark