db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Daniel <dan...@synyx.de>
Subject Re: DatabaseToDdl schemapattern -> writeDataToFile
Date Fri, 23 May 2008 07:58:42 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Tom,

Thomas Dudziak schrieb:
| 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' ?

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 markus.daniel@synyx.de
~ * 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-----

Mime
View raw message