I think everything you describe here falls under CDataPort Ant task
domain, that is standard in 1.2:
http://objectstyle.org/confluence/display/CAYDOC/cdataport
A few months ago I answered a similar question on the Derby mailing
list:
http://mail-archives.apache.org/mod_mbox/db-derby-user/200511.mbox/%
3c66C7D7BD-A58C-4D1D-AED9-DD04DD44EF8..bjectstyle.org%3e
Andrus
On Feb 15, 2006, at 8:52 PM, Tomi NA wrote:
> I'd like to transfer table structure and _data_ from a source mssql
> database to a postgresql database.
> Has anyone here tried something like this? I have a feeling parts
> of cayenne code might be of help, but it's hard to think clearly
> after straight 16 hours of staring at the screen...any suggestions
> would be very welcome.
>
> ...maybe just jdbc level query execution, an xml source db to
> destination db datatype mapping, a query to retrieve the source db
> metadata, a table and column name conversion mechanism (e.g. [dbo].
> [thisName] to this_name), a query generator to generate the raw SQL
> queries to load all the data and insert it into the target database
> tables, additional metadata querying, DDL generation and execution
> to transfer the constraints (keys, indexes, unique value attributes
> etc.) and a "success!" message? :)
>
> I'm thinking...that would be the bulk of it, wouldn't it? I'm
> ignoring procedures, triggers and views, of course. Would anyone be
> interested in using an application facilitating this kind of data
> manipulation? Can anyone suggest a better (simpler, faster, more
> automated) way to do it?
>
> Regards,
> t.n.a.
This archive was generated by hypermail 2.0.0 : Wed Feb 15 2006 - 23:31:00 EST