Manage Learn to apply best practices and optimize your operations.

SQL Server 2005 upgrade: Database components

Upgrading specific database components in SQL Server 2005 can enhance your customers' business. Find out more in this tip.

SQL Server is the engine that fuels many organizations and has empowered the organization to reach new business and IT goals. As such, migrations to SQL Server 2005 have far-reaching affects that were not necessarily the case with migrations to SQL Server 2000.

To truly support the enterprise, SQL Server is now used more than ever before. The following database components should be considered when migrating to SQL Server 2005:

  • Database Engine databases and objects

  • Analysis Services databases and objects

  • Reporting Services objects

  • Extraction Transformation and Loading (ETL) code [i.e., Data Transformation Services (DTS) to SQL Server Integration Services (SSIS)]

  • Notification Services

  • Replication

  • External scripts

  • Middle-tier and front-end applications

  • Third-party tools

  • New application development

Surveying your customer's SQL Server environment to determine which SQL Server components to upgrade as compared to "go forward" applications from a business perspective is important. It ensures that the technical plan is comprehensive and does not experience any false starts. Once you have a clear understanding of the SQL Server components that you will be migrating, then can you determine the best technical options.

Click for the next tip to help you prepare for a SQL Server 2005 upgrade: Requirements for upgrading to SQL Server 2005

This tip originally appeared on

About the author: Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also's Performance Tuning expert. Ask him a question.

Dig Deeper on Database software management

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.