How can you keep your trend data after migrating data warehouse database to different vendor
![]() |
2 answers
![]()
In version 7.0.2 it is possible to migrate data warehouse according to Migrating data from SQL Server to Db2 or Migrating data from SQL Server to Oracle steps.
For older versions there are few options:
|
![]() You (or if not you) then someone who is familiar with database migrations would need to take this on as a project, comparing the table/column definitions between a data warehouse in the source and target database, then transforming the data accordingly. We provide some pointers on the page you reference on the subsequent PUB row to help you get started. These apply to the data warehouse too:
Use database migration documentation/utilities/practices such as the following:
Comments you can think of my post here as a fourth option . Hello Daniel,
If I read well, you say it IS possible to migrate DW from SQL to Oracle successfully using the Oracle SQL Developer database migration utility. Do I read correct?
Myself I don't have Oracle experience, but our Oracle DBA has plenty :)
Regards, Ron Janssen
Ron, the reporting product team successfully migrated the PUB Doc Builder, and they are in the middle of attempting to migrate the data warehouse. We believe it is possible, however we haven't demonstrated that yet. We expect to document the steps once we've done it successfully.
FYI: this task includes questions/issues that have arisen thus far: 550438: Migrating DW from SQL Server to Oracle and test existing reports work
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.