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, for example (18,9) ... and not that much for other uses. That's my point of view.» I must admit I didnt test it from one year. So with the speed you PG hackers work, offering each release a new *major* release (HISTORY items growth 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
