db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: DatabaseToDdl schemapattern -> writeDataToFile
Date Wed, 21 May 2008 16:14:07 GMT
On Tue, May 20, 2008 at 7:02 AM, Markus Daniel <daniel@synyx.de> wrote:

> Hello,
> I have a Oracle Database which contains ddl and data generated by
> torque, now it is necessary to migrate these data to mysql.
> Since torque is not the best tool to dump ddl and data and insert it in
> an other database I try to use DdlUtils.
>
> <databaseToDdl schemapattern="MINOS" modelname="MINOS"
> catalogpattern="MINOS">
> ~    <database url="jdbc:oracle:thin:@192.168.0.82:1521:minos"
> ~              driverClassName="oracle.jdbc.OracleDriver"
> ~              username="minos"
> ~              password="password"/>
>
> ~    <writeSchemaToFile outputFile="oracle-db-schema.xml"/>
> ~    <writeDataToFile determineschema="true" outputFile="oracle-data.xml"/>
> ~  </databaseToDdl>
>
> The schema looks good but not tested at the moment.
>
> The dataDump failed with the message:
> There are multiple columns with the name OBJ_TYPE in the table KU_NOEXP_TAB
>
> This table is not in the schema MINOS it is in the schema system.
>
> Does "writeDataToFile" ignore the schemapattern or it there something
> wrong with my ant target?

DdlUtils shouldn't ignore the schemapattern. Have you tried this with
determineschema='false' ?

Tom

Mime
View raw message