By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

oracle to pg

P: 2
Hi all,

I have a question... our company has a centralised oracle database and few postgress clinets .. we want to replicate or copy a perticular table and column from oracle to pg..

is there any way we can do it with out using any tools in postgress.... oracle should not push the change but postgress should pull the information from oracle..


thx,
Danny
Sep 27 '09 #1
Share this Question
Share on Google+
2 Replies


ssnaik84
100+
P: 149
is there any way we can do it with out using any tools in postgress
Do you want to migrate database without tools?

if not, EnterpriseDB has good migration support
Sep 30 '09 #2

P: 4
If you are not looking to migrate the database, EnterpriseDB also has a replication tool that replicates data from Oracle to Postgres Plus Advanced Server(based on PostgreSQL).

That is a trigger based replication solution. If that doesn't work for you, then you might want to take a look at database links in Postgres Plus Advanced Server. They allow you to create a link between Postgres Plus Advanced Server to Oracle. Then you can create job in the Postgres Plus Advanced Server database that will routinely pull the data, over the link, from Oracle to Advanced Server.

http://www.enterprisedb.com/docs/en/...m#P1970_112702
Nov 5 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.