Detach/Attach to SQL Server 2005

Hello,
We have two developer machines. One is running SS2K and the other is
running SS2005. What we want to do is detach a SS2K database, copy it and
then put it on the other machine and attached it to SS2005. When I attach
the database, will it automatically be upgraded to a 2005 type database, or
is there something else I need to do?
Thanks in advance,
sck10
SQL Server will perform database conversion when attaching database on SQL
2005. You should have seen a messag like :'Converting database 'dbanme'
from version 539 to the current version 607.'
HTH. Ryan
"sck10" <sck10@.online.nospam> wrote in message
news:%23ubCb9$KGHA.3396@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We have two developer machines. One is running SS2K and the other is
> running SS2005. What we want to do is detach a SS2K database, copy it and
> then put it on the other machine and attached it to SS2005. When I attach
> the database, will it automatically be upgraded to a 2005 type database,
> or
> is there something else I need to do?
> --
> Thanks in advance,
> sck10
>
|||>> is there something else I need to do?
Ryan is correct that the database files are converted during the attach
operation. Once you've attached the database to a 2005 instance, you cannot
then detach it and move it back to the 2000 instance.
Also, be aware that the attached database retains it's SQL Server 2000 (80)
compatibility level. This means that the database will behave as if it is on
an instance of SQL Server 2000 for certain features. For example, queries
that contain the old *= and =* operators for outer joins will not work in
SQL Server 2005 when the database is in 90 compatibility level, but they
will work when the compatibility level is set to 80. So, keeping the
compatbility level at 80 may be useful if you need to retain some 2000
behaviors. On the other hand, to use some SQL Server 2005 features, you
will need to explicitly change the compatibility level to 90. For example,
to create database diagrams in SQL Server 2005, the database must be set to
90 compatibility level.
You change the database compatiblity level by using the sp_dbcmptlevel
stored procedure. See the Books Online topic on sp_dbcmptlevel for a list
of behavior changes between 80 and 90 levels.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:OskG4AALGHA.3832@.TK2MSFTNGP09.phx.gbl...
> SQL Server will perform database conversion when attaching database on SQL
> 2005. You should have seen a messag like :'Converting database 'dbanme'
> from version 539 to the current version 607.'
> --
> HTH. Ryan
> "sck10" <sck10@.online.nospam> wrote in message
> news:%23ubCb9$KGHA.3396@.TK2MSFTNGP10.phx.gbl...
>