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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
