• Registered: 2006-09-08
  • Posts: 2

Topic: SQLite -> Postgres

Has anyone had any experience migrating their forums from a SQLite database to Postgres? I keep having locking issues, and it's about time I have a "real" database up anyway.

I'm not really sure where to start; anyone have any pointers?

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: SQLite -> Postgres

I know in phpMyAdmin you can export for PostgreSQL, but I don't know if phpMyAdmin works for SQLite... I bet there are similar tools smile

  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: SQLite -> Postgres

elbekko wrote:

I know in phpMyAdmin you can export for PostgreSQL, but I don't know if phpMyAdmin works for SQLite... I bet there are similar tools smile

I've tried at least half a dozen online interfaces for SQLite, and so far none of them have come anywhere near phpMyAdmin in terms of functionality. sad

Looking for a certain modification for your forum? Please take a look here before posting.
  • Registered: 2006-09-08
  • Posts: 2

Re: SQLite -> Postgres

Did any of those half a dozen interfaces have anything close to a conversion tool?

  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: SQLite -> Postgres

I can't remember if I've tried this one, although I know I've been to its page before: http://www.phpro.org/sqlite/

Looking at its screenshot, it seems to have export functionality.

Also, this page might have something for you: http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

This page might be helpful too: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

I've got some other stuff in my bookmarks, but to put a long story short I don't have easy access to my bookmarks at the moment. sad

If none of the links above help you out, let me know and I'll see what's in my magical bookmarks file.

Looking for a certain modification for your forum? Please take a look here before posting.

6 Reply by deadram (edited by deadram 2006-09-13 08:26)

  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: SQLite -> Postgres

If your on *nix just download the sqlite file, type:
$ sqlite <database> ".dump" > commands.to.input

Then you can open pgsql and copy and past from the commands.to.input text file. Course It's better to recreate the database in pgsql and then import each individual INSERT command. Some minor speed and stability improvements are added in to each CREATE command depending on the database type.

echo "deadram"; echo; fortune;