From: Richard Holland <rholland@equitechinfo.com>
To: pgsql-interfaces@postgresql.org
Subject: Converting Access tables to PostGre
Date: Tue, 5 Dec 2000 08:40:39 -0600
Message-ID: <002201c05ec9$5a09c100$bb00a8c0@equitech> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rholland@equitechinfo.com
Subject: Re: Converting Access tables to PostGre
In-Reply-To: <002201c05ec9$5a09c100$bb00a8c0@equitech>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox