NPM Database Migration

I'm going to migrate my Orion NPM Database from

MS SQL 2000 Enterpriese to MS SQL 2005 enterprise, but...

is there any kind of issue if I change the compatibility level

from 80 to 90?

COMPATIBILITY_LEVEL { 80 | 90 | 100 }

80 = SQL Server 2000

90 = SQL Server 2005

100 = SQL Server 2008

Find more posts tagged with

Did you ever go ahead and do this?

I migrated a little while ago to SQL2005, but when the database restore occurred it restored as compatibility level 80 (SQL Server 2000).

I was wondering if I should make the change to compatibility level 90, but I'm unsure if this will cause an issue...

Dave.

did you guys ever do this? I am looking to go to 100 for some features and am wondering if it will cause an issue.

thanks