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

From: David Fetter <david(at)fetter(dot)org>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to import data from Oracle and SqlServer to a Postgres database?
Date: 2009-11-07 06:42:03
Message-ID: 20091107064203.GB15015@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stanciutheone@gmail.com 2009-11-07 07:58:43 Re: alter table is taking a long time
Previous Message Michael Harris 2009-11-07 06:41:07 Re: alter table is taking a long time