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
No shortcuts that I am aware of.... Chances are, after you've thoroughly analyzed your data set, created your DB schema from your nice pretty ER diagram, properly abstracted your presentation logic into nice shiny ZPTs, crafted your SQL methods, and applied the appropriate python "smart glue".... You'll be done with the porting (rewrite) of your app ;-) Adam (Plan to throw one away, 'cause you will anyway :-) On Sat, 2002-12-07 at 15:00, Michael wrote:
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 )
So in other words, once you commit to Zope as your DB, your stuck with it forever? There is no option to migrate to SQL later on? Michael On Monday 09 December 2002 02:11 pm, Adam Manock wrote:
No shortcuts that I am aware of....
Chances are, after you've thoroughly analyzed your data set, created your DB schema from your nice pretty ER diagram, properly abstracted your presentation logic into nice shiny ZPTs, crafted your SQL methods, and applied the appropriate python "smart glue"....
You'll be done with the porting (rewrite) of your app ;-)
Adam
(Plan to throw one away, 'cause you will anyway :-)
On Sat, 2002-12-07 at 15:00, Michael wrote:
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
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 )
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
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 )
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
participants (3)
-
Adam Manock -
Kevin Carlson -
Michael