On 10/12/06, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Fri, Dec 08, 2006 at 03:55:31PM +0000, Ed Singleton wrote: > > Is there anyway with SQLObject to output all the sql necessary to > > recreate your table with the data as well as the table definitions? > > SQLObject can create sql statements for a specific backend, but it > doesn't output data rows and it cannot automatically convert from a backend > to another backend. > There is a chance SQLObject can help converting the scheme. Connect to > the Pg, draw all tables using fromDatabase, then change the connection to > the SQLite and recreate the tables.
I've already got the scheme, as I created it initially using a SQLObject model. I just want to transfer the data as well. > > If not does anyone know any other way to convert postgres's sql to sql > > suitable for sqlite? > > I see only one way: > > $ pg_dump my_db >my_db.sql > $ vi my_db.sql > $ sqlite <my_db.sql > > I have a script that converts MySQL dump to SQLite. It shouldn't be too > hard to adapt it to Postgres. I can publish the script. That would be wonderful if you could. I guess there are similar differences ;) Ed ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
