Skip to Content

BI Platform migration from Oracle to SQL Server

Do any of you have any information around "Migrating from Oracle DB to SQL Server DB", how/what are the impacts to business objects environments that report off the Oracle data warehouse and Oracle BO repository db.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 25, 2018 at 12:38 PM

    What sort of migration information do you seek ?
    If your BOE was built to report of the Oracle DB - it will not be able to do the same from SQL Server without changing or sometimes re-designing all your universes/connections.

    Add comment
    10|10000 characters needed characters exceeded

    • well, the sql between oracle and SQL server is different. so for each universe you'll have to change where connection is pointing and verify that each object in universe still works , joins etc, custom sql etc...

      As for the CMS DB repo - you can simply use cms db copy functionality and make it easy. Details in Admin guide.