Converting Access tables to PostGre

From: "Richard Holland" <rholland(at)equitechinfo(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Converting Access tables to PostGre
Date: 2000-12-05 14:40:39
Message-ID: 002201c05ec9$5a09c100$bb00a8c0@equitech
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I've come across tons of information on using Access with PostGre, and am thankful for this. Be this as it may, the upsizing tool I
found to convert our access databases to postgre seems to puke on our 800+ meg databases (which is why we're doing this, our
software was created by idiots with no scalability in mind). I downloaded pgadmin, the latest version as of a week ago. This works
great, congrats to it's maintainers. My problem is the same above mentioned idiots used double and single field types to handle
money. Being that our software handles property tax for government counties, we can't have any rounding errors. So I figured on
using the numeric(x,y) type, so I fire up the migration tool built into pgadmin, edit the typemaps to throw singles and doubles to
numeric, and it fails because it doesnt seem to give the numerics a length. It feeds postgre fieldname
numeric(0,lenghtofdecimalsspecifiedinaccess)

this fails.. anybody have a better solution for migrating our data? I can make all 300 tables by hand if need be, but it's getting
the millions of records in i'm worried about.

Thanks in advance,

Richard A. Holland
CCNP,MCSE,CCDA
Equitech Information Systems
417.832.0366

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-12-05 14:40:55 RE: jdbc: getBinaryStream blocks on second call
Previous Message Peter Mount 2000-12-05 14:01:39 RE: JDBC and long TEXT fields