Compatibility level SQL Server 2000 (80) on SQL Server 2005.

Hi,
Does anyone know that after SQL Server 2000 database migrating to SQL Server
2005 server, if the compatibility level still setting on SQL Server 2000
(80), will affect database performance (such insert, update, delete, etc.)?
If I need change SQL Server 2000 (80) level to SQL Server 2005 (90) in
Database Properties for 500 GB database, how long it will take?
Regards!
-Chen
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:0BF2F1FC-AA1E-4D61-B190-9F06596B3962@.microsoft.com...
> Hi,
> Does anyone know that after SQL Server 2000 database migrating to SQL
> Server
> 2005 server, if the compatibility level still setting on SQL Server 2000
> (80), will affect database performance (such insert, update, delete,
> etc.)?
>
Not really, but you can't use many new features until you switch. Since
upgrading requires testing, and changing compatibility level requires
testing, It's better if you change the compatibility level immediately and
get all your testing over with at once.
Only run in 80 compatibility mode if you identify a problem with your
database running in 90 mode that you need more time to fix.

> If I need change SQL Server 2000 (80) level to SQL Server 2005 (90) in
> Database Properties for 500 GB database, how long it will take?
>
It doesn't change the data, so it shouldn't take long.
David