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: 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
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )