Converfting a 2000 db to 2005.

I have a 2000 db that I've restored to a 2005 machine. When it restored it
restored as a version 80 db (2000 I would assume). To convert it to 2005 do
I just go into options and change the compatibility to 90?
Will it tell me if there are things that can't be converted?
TIA - Jeff.It actually upgraded it to 2005 when you restored it. But upgraded dbs are
kept in 80 (2000) computability mode by default. Just change it to 9.0 and
you are all set.
Andrew J. Kelly SQL MVP
"Mufasa" <jb@.nowhere.com> wrote in message
news:ObOhzGicHHA.588@.TK2MSFTNGP06.phx.gbl...
>I have a 2000 db that I've restored to a 2005 machine. When it restored it
>restored as a version 80 db (2000 I would assume). To convert it to 2005 do
>I just go into options and change the compatibility to 90?
> Will it tell me if there are things that can't be converted?
> TIA - Jeff.
>|||OK. I guess the question then becomes why would I want to leave it in 80
compatibility mode?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23lAH6SicHHA.3616@.TK2MSFTNGP05.phx.gbl...
> It actually upgraded it to 2005 when you restored it. But upgraded dbs are
> kept in 80 (2000) computability mode by default. Just change it to 9.0 and
> you are all set.
> --
> Andrew J. Kelly SQL MVP
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:ObOhzGicHHA.588@.TK2MSFTNGP06.phx.gbl...
>|||Perhaps you app hasn't been fully converted to support 90 level yet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mufasa" <jb@.nowhere.com> wrote in message news:OhJYFOjcHHA.1000@.TK2MSFTNGP05.phx.gbl...[vbc
ol=seagreen]
> OK. I guess the question then becomes why would I want to leave it in 80 c
ompatibility mode?
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23lAH6SicHHA.3616@.TK2MSFTNGP05.phx.gbl...
>[/vbcol]|||Aahh. OK. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OA06fRjcHHA.5044@.TK2MSFTNGP05.phx.gbl...
> Perhaps you app hasn't been fully converted to support 90 level yet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:OhJYFOjcHHA.1000@.TK2MSFTNGP05.phx.gbl...
>|||"Mufasa" <jb@.nowhere.com> wrote in message
news:%23wvvy0jcHHA.2332@.TK2MSFTNGP04.phx.gbl...
> Aahh. OK. Thanks.
Note, that things like the query optimizer will be "updated" either way and
this can have adverse consequences in a few degenerate cases.
But overall you probably want to QA your DB under 2005 and change the
compatibility to it as soon as you can.

> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:OA06fRjcHHA.5044@.TK2MSFTNGP05.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hello,
Can you install the Upgrade Advisor and excute the advisor for your SQL 2000
database. Based on the advise you could do nessary chages to make the
database fully
compatibel to SQL 2005.
Thanks
Hari
"Mufasa" <jb@.nowhere.com> wrote in message
news:%23wvvy0jcHHA.2332@.TK2MSFTNGP04.phx.gbl...
> Aahh. OK. Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:OA06fRjcHHA.5044@.TK2MSFTNGP05.phx.gbl...
>sqlsql