Re: Access to postgres conversion

It's 10 tables. that's all. No reports. I will follow your suggestion.
Thanks for the help

On Wed, May 25, 2011 at 4:25 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 05/25/11 12:42 PM, akp geek wrote:
>
>> Dear all -
>>
>> I would like to know if any one has migrated database from MS
>> access to Postgres . We use postgres 9.0.2 on solaris . Are there any open
>> source tools that you have used to do this task. Can you please share your
>> experiences ?
>>
>
> how many tables is this database? is there more to it than just tables?
> (Access isn't really a database, its a data-centric rapid application
> development system). postgres won't do the reports, forms, macros, etc (ok,
> it has user definable procedures/functions, but they aren't in vbasic, and
> they don't work anything like access programs do).
>
> if its just a few tables, it might just be easiest to dump those tables as
> CSV files, then import them one by one into equivalent tables in postgres
> via COPY FROM
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>