<div>
<div class="content wysiwyg-content">
This question is of a general nature; we are in &nbsp;the process of migrating sql 2005 {which is running in compatibility mode with 2000} to sql server 2008 clustered environment.<br />
<br />
2 paths have been proposed:<br />
1)migrate to 2008 and continue to run in 2000 + 2005 compatibility mode - is this even possible since a lot of features have been deprecated in 2008.<br />
<br />
2)migrate to 2008 - how does one identify deprecated code - is there any literature I can refer to on best practises etc.<br />
<br />
thanks.
</div>
</div>


This question is of a general nature; we are in  the process of migrating sql 2005 {which is running in compatibility mode with 2000} to sql server 2008 clustered environment.

2 paths have been proposed:
1)migrate to 2008 and continue to run in 2000 + 2005 compatibility mode - is this even possible since a lot of features have been deprecated in 2008.

2)migrate to 2008 - how does one identify deprecated code - is there any literature I can refer to on best practises etc.

thanks.

migrating sql server 2000/2005 to 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.