Re: Copying Data from Oracle to PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
You can use ora2pg which is one of the best tool for data migration from Oracle to PostgreSQL.

https://ora2pg.darold.net/documentation.html 

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@xxxxxxxxx> wrote:

Hi Experts,

Is there a best tool for me to copying data from Oracle to PostgreSQL?  
The Oracle db named is Cidr and had a few schemas, each schemas owned their own tables, procedures, triggers, functions.  If I create a database on Postgres, how do I copy all schemas from Oracle? Or each schema will become one of the postgreSQL database?

thank you for your helps.

v/r,

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux