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:
- Do not migrate data warehouse vendor. You do not have to migrate your data warehouse if you are migrating the database for base applications.
- Create new data warehouse with new vendor and switch to this new vendor but keep the old data warehouse. If the users will need trend data from the past, they can create the new reports with the old data warehouse, if they need.
-
Install the new database but keep the old one as default for some time. Do not disable data warehouse jobs on any of these databases. Use the old data warehouse for reporting. The purpose of installing a new data warehouse is to start gathering trend report there. Once you decide, that you have enough trend data in the new data warehouse, switch to the new data warehouse and disable DCC jobs on the old one.
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:
- Db2 migration from non-Db2 relational database documentation, see https://www.ibm.com/docs/en/db2/11.5?topic=ueds-migrating-from-non-db2-relational-database-management-systems
- Oracle SQL Developer database migration utility, see https://www.oracle.com/database/technologies/migrating-sql-to-oracle.html
- SQL Server Migration Assistant (SSMA) for Oracle, see https://docs.microsoft.com/en-us/sql/ssma/oracle/migrating-oracle-databases-to-sql-server-oracletosql
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