Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    chile
    Posts
    2

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

    plea
    it's very important
    thanks

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

    Thumbs up as easy as ...

    Hi, it depends where are you exactly ?

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

    http://www.dbtools.com.br
    http://www.pgadmin.org

    then download the Postgresqlsql ODBC driver http://gbord.postgresql.org 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 http://techdocs.postgresql.org/ the are many docs about Oracle migration solutions , one may sweet you "hurried" needs
    the working links are :
    1 - http://www.samse.fr/GPL/ora2pg/ora2pg.html
    2 - http://www.brasileiro.net/postgres/porting/
    >> other links are dead

    http://www.openoffice.org
    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 11:52.
    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
  •