SQL Server 2005 upgrade: Database components

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:

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 SearchSQLServer.com.

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 SearchSQLServer.com's Performance Tuning expert. Ask him a question.

Rate this Tip To rate tips, you must be a member of SearchSystemsChannel.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT Database Deployment and Upgrade Projects The changing database consolidation landscape Maintaining performance after a database consolidation Refining plans for database consolidation Cleaning up with database consolidation services Oracle Database 11g innovations: Get ahead of the game Remote DBA services: Overcoming sales hurdles Computer information systems for small and midsized businesses (SMBs) Web-based database support DBA services can make VARs money Architectural solutions to Web-based applications with large datasets for VARs Server Installation and Upgrades Microsoft System Center Configuration Manager 2007 pre-installation tips Microsoft System Center Configuration Manager 2007 installation steps VMware extends vSphere Enterprise Edition availability Windows Server 2008 Server Core installation Configuring Windows Server 2008 Server Core Upgrading to energy-efficient servers Planning a SharePoint 2003 to SharePoint 2007 migration SharePoint 2003 to SharePoint 2007 pre-migration tasks Server virtualization technology guide Determining a SharePoint Server 2007 upgrade migration plan Database Management Services SQL Server 2008 Reporting Services for high-availability deployment SQL Server 2008 Reporting Services for Internet deployment Key features in SQL Server 2008 Reporting Services editions SQL Server 2008 hardware and software requirements Optimizing SQL Server 2008 performance SQL Server 2008 features study guide How to automate database integration Using continuous database integration and a database 'sandbox' Troubleshooting a failed SQL Server 2008 installation Microsoft SQL Server 2008 guide RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.