Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: does somebody have a script for the oracle migration to postgresql?

    it's very important

  2. #2
    Join Date
    Apr 2003

    Thumbs up as easy as ...

    Hi, it depends where are you exactly ?

    If you're using windows , go and download one of those :

    then download the Postgresqlsql ODBC driver and install it then make two strings one in wich there is the Oracle DSn , one to the new hosting Pgsql DSN , then both tools above permits synchronisation.

    About frunctions and triggers paste them direcly to text files then go and insert them agian in the databse.

    If you're under Linux you can do the same game with UnixODBC and pgadmin (both run on top linux or *nix)

    or you can just down and use both sql plus and plpsql to pipe outputs of oracle in the inputs of psql, you cn rely in sed and awk in those technics.

    The best practice evr is to get the dump of the database (structure and date) and to release it in pgsql , the sysntax is nearly the same if not the triggers and functions !

    at the techdocs site the are many docs about Oracle migration solutions , one may sweet you "hurried" needs
    the working links are :
    1 -
    2 -
    >> other links are dead
    Finally, Openoffice for win/linux - supports natively Postgresql, through a DBA extension that you'll find ion openoffice site, and ODBC databse - offers an other way of migration of data and structures ; functions and triggers must be done separately as said above !

    Good Luck !
    Last edited by karim2k; 11-27-03 at 10:52.
    Open up
    Take a look to my Blog

Posting Permissions

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