Re: [OT?] ETL tools

On Wed, Aug 24, 2005 at 09:50:06AM +0200, Jose Gonzalez Gomez wrote:
> Hi there,
>
> I have started working on a new place where they have a lot of medical
> data stored in relational databases they later exploit with
> statistical software. The situation is a bit chaotic as they're using
> a lot of local Access databases, some databases hosted in an old
> version of Microsoft SQL Server and a lot of data in other non
> relational files (SPSS, Excel, ...). I was hoping to impose a bit of
> order and I started installing a current version of PostgreSQL to host
> all the databases they're using.
>
> I now have two problems:
>
> 1. I have to migrate all the data they currently have to the new
> system, maybe making some transformations in the way.

I generally use Perl for these kinds of tasks. One way that makes
this process less manual is with DBI-Link

http://pgfoundry.org/projects/dbi-link/

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!