Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    11

    Arrow Unanswered: Migrating from MS Access

    I've made a kind of a heavy db application in ms access, and have come to see the need to sometime migrate. I like the pgsql concept, but I've gotten lost looking for the ease of development provided by msaccess...

    ----->Can anyone point out a system for quick pgsql development?

    And btw, and maybe even more important, a system for quick GUI development?

    Thx!

  2. #2
    Join Date
    May 2005
    Location
    San Antonio, Texas
    Posts
    134
    You can use PGAdmin III for DB administration:

    http://www.pgadmin.org/

    You want to find a Rapid Application Development program that gives you ease of use like MS Access. I cannot recommend one (I only used OpenRoad for Ingres), but here is the wiki page and you can start looking into what is out there: http://en.wikipedia.org/wiki/Rapid_a...on_development

    Someone else here might have experience with some.

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Access achieves the "quick development" by tight binding of database to front end. pg was designed as a stand-alone database, as are all database servers.

    pgadmin III works fine for most development tasks. (it comes packaged with pg.) I've also used Database Designer by MicroOlap, which is a graphical reverse engineering and database design tool. (It can reverse engineer almost any ODBC accessible database & generate the script to build the database in PostgreSQL)

    And, VB6 is a fine Windows tool to interface to postgres.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    BTW. The book, PostgreSQL 8 for Windows (Osborne/McGraw-Hill) by Richard Blum, 2007) discusses the differences between PostgreSQL (and database servers in general) and MS Access, and devotes an entire chapter to interfacing Access to PostgreSQL (Using Access as the front end, with pg as the back end.) It also has a brief discussion (2 pages) of the migration of an app from Access to pg.

    Also, review the PostgreSQL 8 For Windows Chapter 1 PDF file, available at McGraw-Hill.

    Check out half.com for good prices.
    Last edited by loquin; 10-09-07 at 14:02.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •