Migration of SQL 2000 to SQL 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Migration of SQL 2000 to SQL 2005

Author

Topic

chetan_dba
Starting Member

21 Posts

Posted - 2008-04-15 : 08:40:42

Hi,
I have one basic question.
What things should i check when i want to upgrade DB Server version to SQL 2000 server to SQL 2005 Server.

Thanks in advance.
-- Chetan

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-15 : 09:50:05

Run the SQL Server Upgrade Advisor ->
http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

It will analyze your current installation and give you information on what pitfalls you can face.

--
Lumbago

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources