On Tue, May 20, 2008 at 7:02 AM, Markus Daniel <[EMAIL PROTECTED]> 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
