Converting Access tables to PostGre
От | Richard Holland |
---|---|
Тема | Converting Access tables to PostGre |
Дата | |
Msg-id | 002201c05ec9$5a09c100$bb00a8c0@equitech обсуждение исходный текст |
Список | 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 upsizingtool 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 tohandle money. Being that our software handles property tax for government counties, we can't have any rounding errors. So I figuredon using the numeric(x,y) type, so I fire up the migration tool built into pgadmin, edit the typemaps to throw singles and doublesto 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'sgetting the millions of records in i'm worried about. Thanks in advance, Richard A. Holland CCNP,MCSE,CCDA Equitech Information Systems 417.832.0366
В списке pgsql-interfaces по дате отправления: