Thread: How to import data from Oracle and SqlServer to a Postgres database?

Hi,

I have one oracle database and one database in sqlserver with data that I need to import to Postgres. Wich is the best way to import data to Postgres?

Sorry for my english.

Best Regards,
André.

One way is that take the dump of oracle in .csv format

Import data into postgres database using copy command.
--
Thanks
Sam Jas



--- On Fri, 6/11/09, Andre Lopes <lopes80andre@gmail.com> wrote:

From: Andre Lopes <lopes80andre@gmail.com>
Subject: [GENERAL] How to import data from Oracle and SqlServer to a Postgres database?
To: pgsql-general@postgresql.org
Date: Friday, 6 November, 2009, 12:03 PM

Hi,

I have one oracle database and one database in sqlserver with data that I need to import to Postgres. Wich is the best way to import data to Postgres?

Sorry for my english.

Best Regards,
André.

---

Try the new Yahoo! India Homepage. Click here.

On Fri, Nov 06, 2009 at 12:03:49PM +0000, Andre Lopes wrote:
> Hi,
>
> I have one oracle database and one database in sqlserver with data
> that I need to import to Postgres.  Wich is the best way to import
> data to Postgres?

One way is to use DBI-Link.  DBI-Link connects from PostgreSQL to the
remote database and allows you to import data from it.

> Sorry for my english.

I assure you, my Spanish is much worse, and my Portuguese is purely a
caution ;)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate