-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Tom,
Thomas Dudziak schrieb: | 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' ? yes, same result <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"/> ~ <writeDataToFile determineschema="false" outputFile="oracle-data.xml"/> ~ </databaseToDdl> BUILD FAILED build.xml:16: There are multiple columns with the name OBJ_TYPE in the table KU_NOEXP_TAB The table KU_NOEXP_TAB is not in the schema minos it is in system... Any ideas? Thanks in advance, Markus - -- /** ~ * Markus Daniel ~ * Bachelor of Science ~ * ~ * Synyx GmbH & Co. KG ~ * OpenSource Solutions ~ * Karlstr. 68 ~ * 76137 Karlsruhe ~ * ~ * phone +49(0)721 66 48 79 31 ~ * fax +49(0)721 66 48 877 ~ * eMail [EMAIL PROTECTED] ~ * www http://www.synyx.de ~ * skype synyx_daniel ~ * irc irc.synyx.de ~ * ~ * Sitz der Gesellschaft: Karlsruhe ~ * Registergericht: Mannheim ~ * Handelsregisternummer: HRA 4793 ~ * USt-IdNr.: DE249264296 ~ * ~ * Komplementärin: Elatech Verwaltungs GmbH ~ * Sitz der Gesellschaft: Karlsruhe ~ * Geschäftsführer: Markus Daniel ~ * Registergericht: Mannheim ~ * Handelsregisternummer: HRB 7250 ~ */ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFINnkyA6KmbVkuXQkRApQMAKCDisN8m72/5PSD3gTq2RFDVI8ZPACg4pWc azNym7GcltfzpSPd1ZRU+0c= =ZKUu -----END PGP SIGNATURE-----
