471,073 Members | 1,330 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Postgres to oracle data migration

Hi all.
We have a production data source running postgres for reporting/DSS
we are thinking on building a warehouse, wherein data would be
transferred from postgres to the warehouse.
The datawarehouse would be implemented in oracle as the plans stand.
I am thereby looking for a solution to relay data between the two,
although the techdocs do mention a way to generate interbase sql and
carry out the migration, not sure if that is the best way for my
project. I would greatly appreciate if you could provide
pointers/suggestions in this direction.
Thanks
Sid
Nov 23 '05 #1
2 4171
phantom wrote:
Hi all.
We have a production data source running postgres for reporting/DSS
we are thinking on building a warehouse, wherein data would be
transferred from postgres to the warehouse.
The datawarehouse would be implemented in oracle as the plans stand.
I am thereby looking for a solution to relay data between the two,
although the techdocs do mention a way to generate interbase sql and
carry out the migration, not sure if that is the best way for my
project. I would greatly appreciate if you could provide
pointers/suggestions in this direction.
Thanks
Sid

One option if you are using Oracle 9i (or greater) is to use the new
external tables option, which will read flat files as a table that
doesn't reside in the db. Or you could use Oracle's SQL*Loader to do the
same thing. If you know perl, C, or java etc, you could also do it that
way (Pro*C, dbi/dbd::oracle)....
I couldn't tell you what the best way is, but some more details may
garner some better answers: os, pg version, oracle version, preferred
language, how frequently the data needs to be transferred....
Nov 23 '05 #2
phantom wrote:
Hi all.
We have a production data source running postgres for reporting/DSS
we are thinking on building a warehouse, wherein data would be
transferred from postgres to the warehouse.
The datawarehouse would be implemented in oracle as the plans stand.
I am thereby looking for a solution to relay data between the two,
although the techdocs do mention a way to generate interbase sql and
carry out the migration, not sure if that is the best way for my
project. I would greatly appreciate if you could provide
pointers/suggestions in this direction.
Thanks
Sid

One option if you are using Oracle 9i (or greater) is to use the new
external tables option, which will read flat files as a table that
doesn't reside in the db. Or you could use Oracle's SQL*Loader to do the
same thing. If you know perl, C, or java etc, you could also do it that
way (Pro*C, dbi/dbd::oracle)....
I couldn't tell you what the best way is, but some more details may
garner some better answers: os, pg version, oracle version, preferred
language, how frequently the data needs to be transferred....
Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by susmita_ganguly | last post: by
4 posts views Thread by Bernardo Robelo | last post: by
4 posts views Thread by Abram Friesen | last post: by
8 posts views Thread by Tavish Muldoon | last post: by
3 posts views Thread by warwick.poole | last post: by
reply views Thread by phantom | last post: by
56 posts views Thread by Ashish Patankar | last post: by
4 posts views Thread by --CELKO-- | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.