<quote> Subject: Conversion Linux/Postgress to Solaris/Oracle Hi all,
We want to convert a MMBase 1.5 environment currently running on
Postgress
SQL 7.1/Linux Redhat 7.3 /Tomcat 4.0-4.1 to a MMBase 1.6 on a Oracle/Sun
Solaris 9/OC4J enviroment.
We have the following questions, does anyone have the answers ?
-How to migrate the current data from Postgress SQL to Oracle, are there
tools/scripts
</quote>
My general aproach in migrating from one database to an other database
is the following:
-first upgrade to the current mmbase (1.6.5) make shure everything works
-copy the configuration/webapp and change the jdbc.xml to point to the
new database
-start both webapps with rmmci enabled
-first copy nodes that are not relation nodes
(for every copied node create a syncnode)
-secondly copy the nodes that are relation nodes
every time look in the syncnodes table to find the "end nodes"
If have some code that does most of the copying work. but it's not an
easy task
the other aproach is to export the data to xml. (how big is your
database , how many nodes?)
<quote>
-Which version of Oracle should be used (8.1.7/9.2.0)
-Will OC4J be supported (Orion server adapted by Oracle)
</quote>
.. My feeling is that its strange to move from linux/postgress/tomcat to
solaris/oracle/oracle as ..... so I am very very interested in your
motivations
<<winmail.dat>>
