I have Windows 2003 R2 Standard SP2 Server running SQL 2000 SP4 Standard

I want to upgrade to SQL 2005 Standard

I only have One Database that is in production use

I was planning to do an inplace upgrade

Any thoughts on this

Should I detach the database first or should I leave it alone

Of course I will make a full backup of the database first


Your thoughts and Ideas will be appreciated

Thanks

Tom

Thomas R Grassi Jr wrote:
I would:

1) use Enterprise Manager to back up your database.
2) Upgrade

I've done this a couple of times with no problems at all...

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
http://mypcassistant.blogspot.com/

I, too, am planning an upgrade to 2005. However, we have over 100 DTS' that
run against the 2000 version. According to the SQL 2005 Upgrade Advisor,
2005 doesn't use DTS' any more. It did say they will continue to run, but I
wonder how they can is 2005 doesn't use them.
"Hank Arnold" <rasilon (AT) aol (DOT) com> wrote

A good reason to have a backup before upgrading.

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
http://mypcassistant.blogspot.com/

paulc wrote:

Yes, DTS is deprecated and does not ship with SQL Server 2005 (or 2008).
However, you can continue to use DTS just fine if you download the optional
installs that can be found here:
http://msdn.microsoft.com/en-us/sqlserver/aa336314.aspx

Download and install the "Microsoft SQL Server 2000 DTS Designer Components
" and "Microsoft SQL Server 2005 Backward Compatibility Components". Then
you can continue to use DTS packages without upgrading them to SSIS.

FWIW,
RLF

"paulc" <paulc (AT) mmcwm (DOT) com> wrote

Thanks, Russell. My boss almost went apoplectic when I told him DTS' were
not suppored in SQL 2005. I think he has over 50 that he uses on a regular
basis.
"Russell Fields" <RussellFields (AT) nomail (DOT) com> wrote