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

Postgres to oracle data migration

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.