Search Postgresql Archives

Re: Access to postgres conversion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux