MSSQL 2000 DB Migration to Microsoft SQL 2005

Hi,
We're building new machine Windows 2003 with MSSQL 2005 server.
We have current machine running Windows 2000 with MSSQL 2000.
How do we migrate the MSSQL2000 database to MSSQL 2005 server?
A) My way: inplace upgrade (i know this one will 99% work!)[vbcol=seagreen]
w/MSSQL2000[vbcol=seagreen]
B) Another way: backup the MSSQL DB from Windows2000 and restore to
Windows2005 with MSSQL2005? work?
C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
work?
Any other way which will guarantee work best?
Thanks for any input!!
J.H"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
This will work.
I would do this.
That way if something "goes wrong" you still have your original 2000 DB and
a backup.
However, no matter WHAT choice you make, make sure to to test your
application thoroughly.
There shouldn't be any gotchas, but you never know.

> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||I did attach/dettach for all my database. Now working wothout any problems.
Don't forget to change compatibility level to 9 after attaching database.
Ramunas
"J.H" <jpthsd@.hotmail.com> wrote in message
news:%239XXAO1aHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We're building new machine Windows 2003 with MSSQL 2005 server.
> We have current machine running Windows 2000 with MSSQL 2000.
> How do we migrate the MSSQL2000 database to MSSQL 2005 server?
> A) My way: inplace upgrade (i know this one will 99% work!)
> w/MSSQL2000
> B) Another way: backup the MSSQL DB from Windows2000 and restore to
> Windows2005 with MSSQL2005? work?
> C) Detach and attach the database from MSSQL2000 and attach to MSSQL2005 ?
> work?
>
> Any other way which will guarantee work best?
> Thanks for any input!!
> J.H
>