Need to move long-term Repository from SQL Server 2000 instance to SQL Server 2008 instance located on the other server.
Following instructions of Solution SOL36323 after restoring of Repository database its compatibility will be 80 (SQL Server 2000). But how to make database compatibility to be 100 (SQL Server 2008), is it enough to switch compatibility from 80 to 100?
Strictly speaking this is a customer choice but we see no reason why you shouldn't change from 8.0 to 10.0 compatibility.
It is more a DBA issue not a Performance Analysis issue but from a Performance Analysis perspective we support it.