Guys,
Today I have a SQL2000 DB running on a Windows2003 server.
I wanna move this DB to a new Server where I also have Windows 2003 Server,
but in this new server I have a SQL2005 version instead SQL2000.
My question:
Is there any tool or Function on the SQL2005 like Attach/De-attach that I
can use to move the SQL2000 DB to the new server with SQL2005? Note that I'm
trying avoid down the DB, export or dump and Import in the new server. This
entire process can take a long time...
Is there a best way to do this avoiding a big Outage ?
Thanks in advance,
Fabio

In SQL Server 2005 Books Online, see the topic -

How to: Upgrade a Database Using Detach and Attach (Transact-SQL)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/99f66ed9-3a75-4e38-ad7d-6c27cc3529a9.htm

You can use detach and attach to upgrade databases, apart from system
databases.

There is a whole section in Books Online, Upgrading to SQL Server, I suggest
you have a read of that.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Monteiro" <Monteiro (AT) discussions (DOT) microsoft.com> wrote