SQL Server upgrade

building semantic layer
1

Hi

Any one tell me whether the SQL Server migration from 2000 to 2005 will affect the BO universe.

Thanks

stalint (BOB member since 2004-12-14)

2

You should be fine. The only this that will change is that you may get some additional functionality from SQL 2005. We went through upgrades recently and did not have to make any changes to our universes.

Depending on what version of Business Objects you are running, you may not be able to use the SQL Native Client option for your data connections. You can still use your same SQL Server 2000 connections with out a problem.

3

Did you change the compatibility level after upgrade? Just an FYI, in an in-place upgrade, the compatibility level remains the same. In this case for example, it will remain 80(SQL Server 200). But if you did side-by-side upgrade, obviously the compatibility level will be 90(SQL Server 2005). You need to be little careful if you did change the compatibility level.

For instance, in 90 compatibility, you need to use the OUTER JOIN syntax to do an outer join, whereas in earlier compatibility levels, you can use ‘=’ and '=’.

So if you have any code that uses the ‘=’ and '=’ syntax for outer joins, the reports will fail.

Hope that helps.

zack :us: (BOB member since 2007-08-02)