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 <pie...@hogranch.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
