> db conversion tool? that sounds interesting. Can you tell more about it?
It's not yet finished, but the configfile should speak for itself:
<convert>
<datasource type="source"
url="jdbc:informix-sqli://testdata01:1527/mmbase:informixserver=dbserver"
username="XYZ
password="XYZ"
driver="com.informix.jdbc.IfxDriver"
prefix="mmb">
<rename>
<builder name="eventepisodeitemstypeclasses">event1</builder>
</rename>
</datasource>
<datasource type="destination"
url="jdbc:oracle:thin:@localhost:1521:boo"
username="mmbase"
password="mmbase"
driver="oracle.jdbc.driver.OracleDriver"
prefix="mm" />
<ignoredbuilders>
<builder name="contentclasses" />
</ignoredbuilders>
<basebuilders>
<builder name="typedef" />
<builder name="reldef" />
<builder name="typerel" />
</basebuilders>
<lastbuilders>
<builder name="oalias" />
<builder name="syncnodes" />
</lastbuilders>
<dependencies>
<builder name="forums" dependson="postings" />
<builder name="forums" dependson="posters" />
<builder name="postareas" dependson="postings" />
<builder name="postareas" dependson="posters" />
<builder name="postthreads" dependson="postings" />
<builder name="postthreads" dependson="posters" />
<builder name="postings" dependson="posters" />
<builder name="icaches" dependson="images" />
</dependencies>
The tool will:
- import the basebuilders first
- import the lastbuilders last
- import builders only when the ones it depends on are already imported.
- rename builders when the 'new' name is differend than the old name
I'm still working on correct CLOB/BLOB handling and stuff like that,
but so far it's working fine. Takes about 5ms per row to my
oracle-on-a-underspecced-laptop, which is actually quite fast if you
ask me.
I might put it in speeltuin someday.
Johannes
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
