Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: how to port Oracle database to PostgreSQL?

    ok, this is what's going on. i have this VB.NET application with Oracle 8.1.7 back end, but now i have to switch the whole thing to PostgreSQL. how do i do that? it's a big database, about 135 tables, a lot of views, triggers, a few stored procedures and functions. i understand there is some tool to do that.

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    database conversion

    there is a perlscript which converts the oracle tables to postgres
    I think it's called ora2pg

    the stored procedures you must rewrite

    We had a migration of a oracle database to postgres
    and all we changed is in the application "MINUS" to "EXCEPT"
    very fast migration
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Wink This is link

    Quote Originally Posted by eperich
    there is a perlscript which converts the oracle tables to postgres
    I think it's called ora2pg

    the stored procedures you must rewrite

    We had a migration of a oracle database to postgres
    and all we changed is in the application "MINUS" to "EXCEPT"
    very fast migration
    it's right here >>http://www.samse.fr/GPL/ora2pg/
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

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