I have read in the newsgroup that someone has suggested that when we detach
a SQL Server 2000 DB and attach it to a SQL Server 2005 Server, it will be
converted to SQL Server 2005 Server (Level 90). However, someone says that
it is still in Level 80 (Nothing has been changed).
I would like to know how many ways to convert 2000 DB to 2005 DB. So far as
I have searched the web, I find that there are 2 ways:
1) In place upgrade of SQL Server 2000 to SQL Server 2005. In this way, all
databases are converted to 2005 level.
2) Use "Copy Database Wizard" in SSMS from SQL Server 2000 to SQL Server
It seems that detach / attach OR backup / restore can convert the SQL Server
2000 DB to SQL Server 2005 DB.
Your advice is sought.