Re: Access to postgres conversion

Tommy <tomgig@xxxxxxxxx> · Wed, 25 May 2011 23:48:17 +0100



    Hi. 

        
        You could try Access to PostgreSQL from Bullzip.com.  I
        liked the dump file that this creates.  Small neat and it is
        free!

    
    Tommy.

    
    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