Jim C. Nasby wrote:
On Mon, Feb 06, 2006 at 05:30:39PM +0100, Laurent Goussard wrote:Hi there, I use SQLite on my website for 2 years now. I do like SQLite a lot and will use it for a lot of new web projects but, because I got more and more traffic, I consider to move this one to MySQL in order to reduce the over load of my computer (I host it @ home). Do you know if there is a way to convert easily an SQLite database into a MySQL one ? (I'm especially thinking about the escapestring and other "create table [myTable] {" issues...)FWIW, I believe SQLite's syntax is closer to PostgreSQL's than it is to MySQL, so it might me easier to migrate that direction...
If you are migrating to an enterprise level DBMS, PostgreSQL is a better choice than Mysql. It is fully featured with all the qualities of DB2 and Oracle but without the expense.
Note that you will need considerably more machine resources to run a "heavier" DBMS than Sqlite. For example on our 166MHz, 256MB RS/6000 PostgreSQL is sluggish but on our dual processor 1.2GHz, 2GB P-Series it is lightning fast. Sqlite runs fast on the 166MHz machine.
