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 - 20:52:44 EST