Обсуждение: Migration
Does anybody know how complicated the migration progress from postgresql 7.0.2 to oracle 8 would be?? Christian HERBERT Web Programmer WWW.OVEN.COM THE OLD TRUMAN BREWERY 91 BRICK LANE LONDON E1 6QL T: 020-7247-4778 F: 020-7247-9448 M: 07946-507-317 E: christian@oven.com
On Tue, Aug 08, 2000 at 02:39:45PM +0100, Christian Herbert wrote: > Does anybody know how complicated the migration progress from postgresql > 7.0.2 to oracle 8 would be?? Hmm, I'm not sure Don Baccus follows this list, otherwise I'd let him answer this one (since it's his doc I'm going to point you at). Mostly we like to encourage people to go the other way, but we all know there are reasons why on might have to stop using postgresql. Still, is there an interesting reason? Some feature missing that you've got to have? The developer's would like to know! Anyway, there's a porting guide for Oracle -> Postgresql at: http://www.openacs.org/doc/openacs/html/oracle-to-pg-porting.html You should be able to use that in reverse, as it were. Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
We are not looking to migrate to Oracle immediately... but the request is to keep the option open for future migration. -----Original Message----- From: pgsql-interfaces-owner@hub.org [mailto:pgsql-interfaces-owner@hub.org]On Behalf Of Ross J. Reedstrom Sent: 08 August 2000 16:00 To: pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] Migration On Tue, Aug 08, 2000 at 02:39:45PM +0100, Christian Herbert wrote: > Does anybody know how complicated the migration progress from postgresql > 7.0.2 to oracle 8 would be?? Hmm, I'm not sure Don Baccus follows this list, otherwise I'd let him answer this one (since it's his doc I'm going to point you at). Mostly we like to encourage people to go the other way, but we all know there are reasons why on might have to stop using postgresql. Still, is there an interesting reason? Some feature missing that you've got to have? The developer's would like to know! Anyway, there's a porting guide for Oracle -> Postgresql at: http://www.openacs.org/doc/openacs/html/oracle-to-pg-porting.html You should be able to use that in reverse, as it were. Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
On Tue, Aug 08, 2000 at 04:22:00PM +0100, Christian Herbert wrote: > We are not looking to migrate to Oracle immediately... but the request is to > keep the option open for future migration. Fair enough. That's how I convinced my team to using postgresql for our project: use postgresql for development, and move to Oracle if needed for scale up. In that light, the trick is to stick with bog standard SQL: use no special features of pgsql. Or if you do, make sure they're either Oracle compatability features, or that there is a simple Oracle replacement. Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005