On 2/16/06, Tore Halset <halse..vv.ntnu.no> wrote:
>
> 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.
I've just managed a data port using MS DTS, accessing the pgsql database via
ODBC. The downside is that I had to manually change all the target table and
attribute names to lowercase (a really, really boring task!) and the port is
*very* slow. I lost all keys and indexes, as well. :(
Cayenne will create primary keys and relationships, but not that much
> more.
Really? It'll transfer keys to the target database, even though only the
basic table structure in the target database is defined?
> 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.
I'll probably give it a go.
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.
Oh well. :) I should have waited for your reply. Still, what exactly do you
mean by "not as good"?
t.n.a.
This archive was generated by hypermail 2.0.0 : Thu Feb 16 2006 - 09:34:05 EST