On Feb 16, 2006, at 02:52, 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.
I have moved data between mssql and postgresql several times using
dataport. It may use too much memory if your database contains large
blobs.
> ...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? :)
Cayenne will create primary keys and relationships, but not that much
more.
> 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?
dataport works best for me.
MS SQL Server (yes, silly name) has something called Enterprise
Manager (another cool name) that are able to move data between odbc-
datasources. It sort of works, but not as good as dataport.
- Tore.
This archive was generated by hypermail 2.0.0 : Thu Feb 16 2006 - 00:58:58 EST