Hi, to followup myself, I found that
ddlutils do have a notion of a table
name match pattern (note: the pattern is
case sensitive for quite a few database
vendors) but no "end user" interface to
select to-be-dumped databases. So I did
create the following ugly patch:
diff
src/java/org/apache/ddlutils/platform/postgresql/PostgreSqlModelReader.java{.org,}
50c50
< setDefaultTablePattern(null);
---
> setDefaultTablePattern("mytable"); // EVIL!
Wildcards would be allowed here, too,
but I think you cannot write a list
of tables here? The pattern ends up
being passed to
java.sql.DatabaseMetaData.getTables
deeper inside ddlutils.
Hi, I noticed that you can specify:
- the catalog(s)
- the schemas(s)
- the table TYPES
but not:
- the table names
in the DatabaseToDdlTask.
...
What I am trying to do is to dump a single
table from a database to some XML file.
...
Regards, Eric
PS: Maybe somebody can forward this to the
developer list and the DatabaseToDdlTask and
DdlToDatabaseTask can have a real user
interface for table selection in future
versions of ddlutils. Thanks!
PPS: I noticed that I had to use
ANT_OPTS=-Xmx1024M
to avoid running out of JVM heap space. The
processing was fast enough and the created
XML files are nice and clean, thank you :-).
