Le Friday Oct 17, 2003 at 10:10:26AM +0200, Jean-Michel POURE a écrit :
> Dear friends,
>
> I would like to port Compiere CRM from Oracle to PostgreSQL (and release it
> for free).
Hi Jean-Michel,
I did Red-Hat CCM Migration from Oracle to PostgreSQL a year ago when I
was the dba of IdealX, a french Open Source Services company in France,
you may know it. Since the job has been done for french public affairs,
I hope IdealX and this ministry did publish it GPL, I'm gonna get some
informations, I'll keep you on touch.
I do copy an Oracle production database everyday into a PostgreSQL one,
for web sites needs: production database is under Oracle, web reporting
database is on a LAPP server. (not LAMP ;-).. ).
I succeeded using oracle contrib (look at contrib/oracle or directly
to Gilles's DAROLD web at: http://www.samse.fr/GPL/).
Ora2pg is fast, simple and accurate, it handles PG schemas too, etc..
Beware of numeric(x,y) PG type, it's really slow, prefer integer
datatype. For example, translate a NUMERIC(3,2) into INTEGER. Just *100
the value, and modify client side (/100), it will be really faster (that was
the simple solution we found on another migration project at IdealX...).
[ As I told it here (http://www.geocrawler.com/archives/3/104/2002/5/0/8597590/)a year ago:
« Be aware that NUMERIC(x,y) in PG is very powerfull for atypic uses, forexample (18,9) ... and not that much for other
uses.That's my point ofview.»
I must admit I didnt test it from one year. So with the speed you PGhackers work, offering each release a new *major*
release(HISTORY itemsgrowth can show this: amazing..), I think maybe this is no more true...
]
I'd like to help you in your project, since I'm Oracle/PG experimented
DBA, and I need a good CRM solution for personal and profesional
purposes.
Please tell me if my experience can help you in any way, I'd be really
glad in participating your project.
I can offer public CVS, web, etc.. for the project if you want.
Overall, I think we're both French ;-))
Cheers,
--
Jean-Paul ARGUDO
DBA Oracle, PostgreSQL, MySQL, Ingres
Membre de l'April http://www.april.org