Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2001
    Posts
    2

    Unanswered: Migration from Oracle to Postgresql

    I believe this topic is quite frequently asked here or in the postgresql mailing list . I have searched this forum and have indeed asked the question at postgresql mailing list but couldn't get any other answer except suggestions to check on techdocs. The problem is, out of 4 links to the articles, only one is ok, whereas other 3 links are dead links..

    so, any other pointers on where can I dig up some more info on the topic?

    TIA.

    cheers,
    Faizol
    Last edited by Faizol Halim; 05-19-03 at 15:49.

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

    Thumbs up Migration is cool

    I see that u want to do it really the easiest way to do that is simply to do it through ODBCs , u install the Oracle ODBC , and the Pgsql ODBC , then migrate with a simple software or just a vb or c program that you'll create you're self, I'll advice you agin http://www.dbtools.com.br wich treats Postgresql bu have very big posiblities of migration, u can import you DB from :
    A Text file with sparators (usually | the pipe)
    From an Excel file .
    From a dbase 3/4/5 DB (oracle is able to export one)
    Or just from an existing ODBC , wich is the easiest way.
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

  3. #3
    Join Date
    Nov 2002
    Location
    London
    Posts
    47
    Hi

    Following on from the previous poster, you need both ODBC drivers for Postgres and Oracle. With Virtuoso, a tool by the company I work with, OpenLink Software, you can link in tables from both sources and replicate data between the two at regular intervals if you wish.

    HTH
    Emmon Simbo

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

    Thumbs up Comercial

    You solution is cool , but needs commercial material
    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
  •