Re: MSSQL7 & PostgreSQL 7.0

Peter Mount wrote:
>
> I don't think it's a shameless plug at all.
>
> However, I think it's sometimes useful to know alternative methods of
> doing things, especially when you have to work for people who think
> Microsoft are the best thing since sliced bread ;-)
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council.
>
> -----Original Message-----
> From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> Sent: Thursday, May 18, 2000 9:34 AM
> To: 'pgsql-hackers(at)postgresql(dot)org'
> Subject: RE: [HACKERS] MSSQL7 & PostgreSQL 7.0
>
> Feel free to tell me where to go if you think this is a shameless
> plug(!)
> but pgAdmin also includes tools for migrating data from any ODBC
> datasource
> (as well as ascii text files) to PostgreSQL. I'm open to suggestions if
> anyone feels there are improvements worth making....

Firstly I have to say its a great bit of work (pgAdmin), however it'd be
nice to see an open source tool mirroring the functionality of the DTS. I
especially liked the way you could script the mappings between fields, as
well as the GUI builder for complex transforms (in fact I absolutely loved
that (when it worked :), I had too long on the beta). As well as being able
to use pre- and post- conditional actions upon success/failure of certain
parts, like emailing, calling other programs etc.

Regards,
Joe

> Regards,
>
> Dave.
>
> --
> "If you stand still, sooner or later something will eat you."
> - James Burke
> http://www.vale-housing.co.uk/ (Work)
> http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)

--
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj(at)kpi(dot)com(dot)au