Hi,

I am a beginer in SQL Server.
I have to migrate SS2000 to SS2500
what is the best path ?
- installation SS2005

- upgrade ?
- detache/attach ?
- backup ?

Can I desinstall SS2000 after upgrade ?
pitfalls ?
Thanks in advance

bob123 (bob123 (AT) gmail (DOT) com) writes:
What is the context? Is this a production system? Or is it just your
development workstation? If it is a production system, what kind of
applications do you have? In-house apps? Third-party applications?

What features do you use? Replication? DTS? Cluster? Agent?

Personally I prefer to make a new installation and move databases with
BACKUP/RESTORE. But if it is a production machine that you don't intend
to replace, this is a bit problematic, as you would have to install
SQL 2005 as a new instance, which means that all connection strings
and similar that points to the server has to be updated. In that case,
an inplace upgrade may be a better choice. An inplace upgrade also saves
you the hassle to migrate logins and jobs.

Pitfalls?
o Have you verified that the applications support SQL 2005 at all?
o There is a checking tool of which the name escapes me now, but
which can checks for compatibility issues.
o Beware that databases are in compatibility mode 80 after the
upgrade (no matter the method). Youl will need 90 to use all new
features in SQL 2005.
o If you do an inplace upgrade, stop SQL Server and take a complete
Windows backup of the machine. And backup your databases the SQL
way too.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

OK thanks

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> a écrit dans le message de news:
Xns9D1AF3A7EC634Yazorman (AT) 127 (DOT) 0.0.1...