I have made a few fixes to be able to export/import data using schemas (on PostgreSQL), see files included at the end of the post.
Most of them are quite ugly fixes but that works for me ... and still, they should not interfere with other people usage.
Main problem fixed in included files were:
- reading a model from XML file (schema is not handled then).
- INSERT INTO was not prefexing table names with schema name.
- writeDataToDatabase methods were not handling _determineSchema property.
(neither was writeDataToXML but I fixed that previously - see september post).
I've added a new method in class DatabaseIO:
public Database read(String filename, String schema)
to be able to pass the schema as a parameter.
It's fixed in another way in DdlToDatabaseTask.
If anybody is interested in more explanations, feel free to ask.
Moving forward (in next versions), I would assume that it would be better to add the schema in the XML file produced.
The question is: once in the file (e.g. in the <data> tag)
that will mean only one schema per file,
or per table (in each line) - that will mean being able to export the complete database with all schemas.
The diff file applies to version 1.0 not the latest SVN files.