It’s probably a bit of a weird post. Especially since SQL Server 2008 is already anounced. But in the company I work for we are only now making the switch from SQL Server 2000 to SQL Server 2005.
So here are some of the things that I encountered:
- There are no incompatabilities in the database engine itself. So that is smooth sailing, thank god!!!
- The Analysis Services are completely different, which means you will have to rewrite all cubes and dimensions.
- If you’re using PivotCharts and Excel to connect to your cubes you’re gonna need to rewrite huge parts of them
Let me explain point two. Analysis services has the capability to migrate all the cubes you had in Analysis Services 8, but since the service has changed so much it’s useless. After the migration you won’t be able to edit the cubes any more. So you’re better of starting from scratch.
I’ve been working on the migration non-stop for three weeks now. It’s mostly that slow because I have to process the cubes every time I make a change to fix a bug. And for some cubes this takes a few hours.