Universe Connection - SQL 2000 to 2005 upgrade

[Former Member]

We are using Designer 11.5.0.0 and have a Universe that is designed as Secured Type, OLEDB connection to a SQL Server 2000 Server/Database and WEBI reports have been developed using this Universe.

The plan is to upgrade to SQL Server 2005 and there will be no changes to any of the database tables that are used in the Universe.

My first question is .... once that happens, do I need to do anything to the Universe like update the connection, export it or anything else?

Second question is .... once the Universe is "upgraded" to the new SQL Server 2005 server/database, will the reports still work or do they need to be modified in any way?

Thanks for your comments !

[Former Member · Accepted solution]

One thing make sure that the schema name or owner name should be same along with the table names in the new database.

In the designer create a new connection pointing to the new database, export the universe to the CMC.

1) make sure that you use the proper middleware to create the new connection. pionting to new database.

2) No need to do any changes to the reports... the reports will take the connection used to the universe.

Thanks,

Surendra.C