Moving from 2000 to 2005

[myvision69]

How hard is it to move from 2000 to 2005?

I have 200 installs of MSDE 2000 and one database that would need to be upgraded. How should I implement it?

 

[mrdenny]

I always reommend doing an uninstall then an install of the new edition. The upgrade is supose to be fairly smooth, but you never know.

To use my method, you'll need all your jobs, DTS packages, and usernames and passwords before you do the uninstall.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Regardless of what method you use to move to SQL Server 2k5, you should always back up your databases, DTS packages and all other relevant information. ESPECIALLY your DTS packages.

2k5 doesn't use DTS, it uses SSIS which was a re-written from-the-ground-up DTS. Dynamic properties no longer work and Active X scripts will cause a package to call the SQL 2000 DTS executable to run the package, so all your DTS packages will probably have to be redesigned when you upgrade.

I haven't heard of any retired datatypes, so your dbs should be fine. It's mainly the DTS packages you'll have to worry about.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.