pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreplication from Oracle to PostgreSQL?
11+ messages / 8 participants
[nested] [flat]
* replication from Oracle to PostgreSQL?
@ 2011-08-11 14:41 CS DBA <cs_dba@consistentstate.com>
0 siblings, 4 replies; 11+ messages in thread
From: CS DBA @ 2011-08-11 14:41 UTC (permalink / raw)
To: pgsql-admin
Hi All;
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
Thanks in advance...
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 14:53 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: CS DBA <cs_dba@consistentstate.com>
3 siblings, 1 reply; 11+ messages in thread
From: Devrim GÜNDÜZ @ 2011-08-11 14:53 UTC (permalink / raw)
To: CS DBA <cs_dba@consistentstate.com>; +Cc: pgsql-admin
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bundled.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 14:54 Chris Ernst <cernst@zvelo.com>
parent: CS DBA <cs_dba@consistentstate.com>
3 siblings, 0 replies; 11+ messages in thread
From: Chris Ernst @ 2011-08-11 14:54 UTC (permalink / raw)
To: pgsql-admin
On 08/11/2011 08:41 AM, CS DBA wrote:
> Hi All;
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
>
>
> Thanks in advance...
>
I believe EnterpriseDB Advanced Server does it
(http://www.enterprisedb.com/)
--
Chris Ernst
Data Operations Engineer
Zvelo, Inc.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 14:57 CS DBA <cs_dba@consistentstate.com>
parent: Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 2 replies; 11+ messages in thread
From: CS DBA @ 2011-08-11 14:57 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: pgsql-admin
> On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>> Anyone know of tools / options that will allow Oracle to PostgreSQL
>> replication? or at least a real time feed or dblink?
> EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
> solution bundled.
>
> Regards,
That was the first thing I tried to push 'em towards... they shut it
down cause it's not free (which is weird since they're not considering a
real TCO, but they are the customer).
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 16:25 Simon Riggs <simon@2ndQuadrant.com>
parent: CS DBA <cs_dba@consistentstate.com>
3 siblings, 0 replies; 11+ messages in thread
From: Simon Riggs @ 2011-08-11 16:25 UTC (permalink / raw)
To: CS DBA <cs_dba@consistentstate.com>; +Cc: pgsql-admin
On Thu, Aug 11, 2011 at 3:41 PM, CS DBA <cs_dba@consistentstate.com> wrote:
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
2ndQuadrant has various in-house tools for fast migration from Oracle
to PostgreSQL, but those aren't designed for long term co-existence,
just for minimising the window of downtime at cutover. It's not been
weaponised, so its not available for free download.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 18:23 M. D. <lists@turnkey.bz>
parent: CS DBA <cs_dba@consistentstate.com>
3 siblings, 0 replies; 11+ messages in thread
From: M. D. @ 2011-08-11 18:23 UTC (permalink / raw)
To: pgsql-admin
On 08/11/2011 08:41 AM, CS DBA wrote:
> Hi All;
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
>
>
> Thanks in advance...
>
SymmetricDS is capable of doing replication one DB to another, but I've
never used it so cannot speak from experience.
Mark
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 19:58 Joshua D. Drake <jd@commandprompt.com>
parent: CS DBA <cs_dba@consistentstate.com>
1 sibling, 1 reply; 11+ messages in thread
From: Joshua D. Drake @ 2011-08-11 19:58 UTC (permalink / raw)
To: pgsql-admin
On 08/11/2011 07:57 AM, CS DBA wrote:
>
>> On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>>> Anyone know of tools / options that will allow Oracle to PostgreSQL
>>> replication? or at least a real time feed or dblink?
>> EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
>> solution bundled.
>>
>> Regards,
>
> That was the first thing I tried to push 'em towards... they shut it
> down cause it's not free (which is weird since they're not considering a
> real TCO, but they are the customer).
I would aimagine it would be pretty simple to fork the triggers that do
replication in Londiste or Slony (as long as everything else was
PostgreSQL) to be able to replicate from Oracle to PostgreSQL.
JD
>
>
>
>
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-11 21:37 Greg Smith <greg@2ndQuadrant.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 11+ messages in thread
From: Greg Smith @ 2011-08-11 21:37 UTC (permalink / raw)
To: pgsql-admin
On 08/11/2011 03:58 PM, Joshua D. Drake wrote:
> I would imagine it would be pretty simple to fork the triggers that do
> replication in Londiste or Slony (as long as everything else was
> PostgreSQL) to be able to replicate from Oracle to PostgreSQL.
That's the approach taken by some of our in-house tools. "simple"
wouldn't be the right word to describe the process that went into
building them though. You have to get the basics working, then worry
about non-deterministic statements (random, timestamps, etc.),
sequencing, all of the stuff any statement based replication can be
faced with--except now there's the quirks of two databases to worry about.
One of the reasons Slony and Londiste statement extraction works as well
as it does is because new functions were added to PostgreSQL 8.3 for
them, to make it easier to get the sort of snapshot information needed
to grab consistent copies of data. That problem comes back again when
the origin database isn't a PostgreSQL one too.
There are a couple of ways to solve this problem, but all of them are
complicated enough that they're only sitting in commercial/consultant
projects right now (in addition to ones mentioned here already, I'm sure
Continuent has some applicable stuff too). I think Kevin's customer may
be in for a surprise at how much it will cost to duplicate this feature
set from scratch--I'd be surprised to see that total come in under what
licensing an already built package would sell for. Companies who aren't
willing to throw some money toward buying/customizing at least some
PostgreSQL software, if it allows escaping from Oracle licensing, should
reconsider their strategy. Not everything you'll want to make a
conversion easy is going to be free.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-12 02:09 Craig Ringer <ringerc@ringerc.id.au>
parent: CS DBA <cs_dba@consistentstate.com>
1 sibling, 1 reply; 11+ messages in thread
From: Craig Ringer @ 2011-08-12 02:09 UTC (permalink / raw)
To: CS DBA <cs_dba@consistentstate.com>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin
On 11/08/2011 10:57 PM, CS DBA wrote:
>
>> On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>>> Anyone know of tools / options that will allow Oracle to PostgreSQL
>>> replication? or at least a real time feed or dblink?
>> EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
>> solution bundled.
>>
>> Regards,
>
> That was the first thing I tried to push 'em towards... they shut it
> down cause it's not free (which is weird since they're not considering a
> real TCO, but they are the customer).
Using Oracle ... and objecting to "not free"?
*boggle*
There are lots of ETL tools available, and there's always the
roll-your-own queue-based trigger replication system option. Of course,
both options would probably cost more than buying EDB's already built
and tested version...
--
Craig Ringer
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-12 14:40 CS DBA <cs_dba@consistentstate.com>
parent: Craig Ringer <ringerc@ringerc.id.au>
0 siblings, 1 reply; 11+ messages in thread
From: CS DBA @ 2011-08-12 14:40 UTC (permalink / raw)
To: Craig Ringer <ringerc@ringerc.id.au>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin
On 08/11/2011 08:09 PM, Craig Ringer wrote:
> On 11/08/2011 10:57 PM, CS DBA wrote:
>>
>>> On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>>>> Anyone know of tools / options that will allow Oracle to PostgreSQL
>>>> replication? or at least a real time feed or dblink?
>>> EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
>>> solution bundled.
>>>
>>> Regards,
>>
>> That was the first thing I tried to push 'em towards... they shut it
>> down cause it's not free (which is weird since they're not considering a
>> real TCO, but they are the customer).
>
> Using Oracle ... and objecting to "not free"?
That's why we're here - to help 'em migrate from Oracle to PostgreSQL,
it seems some systems will need a longer Oracle life due to other
constraints
>
> *boggle*
agreed
>
>
> There are lots of ETL tools available, and there's always the
> roll-your-own queue-based trigger replication system option. Of
> course, both options would probably cost more than buying EDB's
> already built and tested version...
>
interesting idea, any specific ETL tools you could recommend?
> --
> Craig Ringer
>
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: replication from Oracle to PostgreSQL?
@ 2011-08-12 23:37 Craig Ringer <ringerc@ringerc.id.au>
parent: CS DBA <cs_dba@consistentstate.com>
0 siblings, 0 replies; 11+ messages in thread
From: Craig Ringer @ 2011-08-12 23:37 UTC (permalink / raw)
To: CS DBA <cs_dba@consistentstate.com>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin
On 12/08/2011 10:40 PM, CS DBA wrote:
>> There are lots of ETL tools available, and there's always the
>> roll-your-own queue-based trigger replication system option. Of
>> course, both options would probably cost more than buying EDB's
>> already built and tested version...
>>
> interesting idea, any specific ETL tools you could recommend?
The main open source ones I hear about are Talend
(http://uk.talend.com/index.php) and Pentaho (http://www.pentaho.com/).
These are the only two I hear of people on this list using, but that
doesn't mean others don't see use too.
Others found in a quick search include CloverETL
(http://www.cloveretl.com/) and Aptar (http://apatar.com/). I'm sure
there are tons more, but who knows what they're like.
--
Craig Ringer
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2011-08-12 23:37 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-11 14:41 replication from Oracle to PostgreSQL? CS DBA <cs_dba@consistentstate.com>
2011-08-11 14:53 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2011-08-11 14:57 ` CS DBA <cs_dba@consistentstate.com>
2011-08-11 19:58 ` Joshua D. Drake <jd@commandprompt.com>
2011-08-11 21:37 ` Greg Smith <greg@2ndQuadrant.com>
2011-08-12 02:09 ` Craig Ringer <ringerc@ringerc.id.au>
2011-08-12 14:40 ` CS DBA <cs_dba@consistentstate.com>
2011-08-12 23:37 ` Craig Ringer <ringerc@ringerc.id.au>
2011-08-11 14:54 ` Chris Ernst <cernst@zvelo.com>
2011-08-11 16:25 ` Simon Riggs <simon@2ndQuadrant.com>
2011-08-11 18:23 ` M. D. <lists@turnkey.bz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox