Forum OpenACS Q&A: Response to Oracle 816 Data to PostgreSQL 7.1.3

Collapse
Posted by Michael A. Cleverly on
We did a conversion about a year ago from a custom AOLserver/Solid system to ACS 4.2 Classic on Oracle 8.1.6.  We wrote a series of scripts to crank data out of Solid, possibly munge it a bit, and insert it into Oracle.  We used (surprise, yet another shameless plug), nstcl.  This let us use the database API with both databases.  We could have configured an AOLserver instance to talk to both databases, but then we'd have had to use the old fashioned ns_db interface to one (or both) of them.

I'd be happy to share our scripts if someone is curious at looking at them, though since I imagine we're the only ones to have ever done an AOLserver/Solid to ACS/Oracle migration (and even if we weren't, no one else would have had our legacy data model :^) I don't know that they'd be of any real specific use to anyone.

I'd be happy to help with any effort to create conversion scripts for 4.2 Classic/Oracle to OpenACS/Postgres.

Collapse
Posted by Thara S Pillai on
Hello, I am a computer Application postgraduate student from India. I have to do one project that includes conversion module of oracle database at Unix server to postgresql at Linux. Server in use is Apache. Can you please forward some help? Many thanks in advance, Thara. Semester-6, MCA, College of Engg., Trivandrum Kerala, South India.
Collapse
Posted by Jade Rubick on
Thara, look at this document: http://openacs.org/faq/one-faq?faq_id=43841