[Zope] ZODB / SQL question

Michael mlewis@exasource.com
Tue, 10 Dec 2002 09:53:07 -0700


Thanks Adam,

This gives me something to work on now.

Michael

On Monday 09 December 2002 05:44 pm, Adam Manock wrote:
> I do not know how your site is set up, but if your data in the ZODB is
> consistent in structure and well separated from your logic and
> presentation code, what you want to do should not be too difficult. You
> should concentrate on two tasks:
>
I> 1)	The actual data migration, "selecting" your data from the ZODB
> 	and outputting it in a form that can be brought into PostgreSQL.
> 	You may be able to parse a Zope XML export file to create a 	source
> file for Postgres:-) Then....
> 	(COPY http://www.postgresql.org/idocs/index.php?sql-copy.html)
>
> 2)	Creating SQL queries that return results in the same form that
> 	your logic / presentation code expects. (You may be able to 	create an
> "abstraction layer" product or script to do this
> 	that can be used everywhere)
>
> Hope that helps,
>
> Adam
>
> On Mon, 2002-12-09 at 18:50, Michael wrote:
> > Sorry, I guess i'm not being very clear. I'm not looking for a shortcut. 
> > I built a job board in Zope using ZODB.  I want to keep the app in zope,
> > but move the records that have been created, (ie: the jobs that have been
> > entered) to Postgres.  Postgres and psychopg are installed.  I was just
> > wondering if there was a how-to or some other form of documentation on
> > how to accomplish this.  The only thing I can find is how to set up Zope
> > or SQL from the start.
> >
> > Michael
> >
> > On Monday 09 December 2002 04:24 pm, Kevin Carlson wrote:
> > > Not really a shortcut, but you could export each folder in the root
> > > folder of the ZODB installation and import the .zexp files into the SQL
> > > installation.
> > >
> > > Kevin
> > >
> > > -----Original Message-----
> > > From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> > > Michael
> > > Sent: Saturday, December 07, 2002 3:01 PM
> > > To: Zope List
> > > Subject: [Zope] ZODB / SQL question
> > >
> > >
> > > Is there some documentation on how to migrate from an existing ZODB
> > > application to SQL?  I seem to only find info on setting up and using
> > > one or the other, but now how to switch from one to the other.  Any
> > > pointers would be appreciated.
> > >
> > > Michael
> >
>