Upgrading to SQL Server 2005: A dozen must-have tips

SQL Server 2005 goes above and beyond its predecessors in terms of both programming and administrative features. We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005. Get information on backward compatibility issues, the coexistence of SQL Server 2005 and 2000 on the same machine, migrating with the Copy Database Wizard and more.

SQL Server 2005 goes above and beyond its predecessors in terms of both programming and administrative features. Have you already upgraded or are plans in the works? We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut. Get information on backward compatibility issues, the coexistence of SQL Server 2005 and 2000 on the same machine, migrating with the Copy Database Wizard and more.

#1 -Compatibility of SQL Server 2005 and 2000 coexisting
So, you've decided to upgrade your databases to SQL Server 2005. Our database expert highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server 2000 machine. Also discussed are options for interaction between the two versions, such as linked servers, multi-server administration and log shipping.

#2 - Upgrading to SQL Server 2005: Six migration tips
When upgrading to SQL Server 2005, there are a number of things to consider. It starts with getting to know SQL Server 2005 before the actual upgrade and ends with optimizing your new SQL Server 2005 setup. Windows expert Serdar Yegulalp outlines six points to be aware of when migrating.

#3 - Migrating SQL Server 2000 DTS packages to SSIS
SQL Server Integration Services is more than a replacement for SQL Server 2000's Data Transformation (DTS) packages. The scale of changes is vast and this SQL Server 2005 ETL platform more powerful. In his tip, contributor Joe Toscano helps make the migration as painless as possible by guiding you through using the necessary transitional tools of SQL Server 2005 Upgrade Advisor and Package Migration Wizard.

#4 -Q&A: Writing stored procedures in SQL Server 2005
When writing stored procedures in SQL Server 2005, you have options beyond T-SQL. Learn the benefits of writing stored procedures using CLR (Common Language Runtime) and how to convert existing stored procedures to the CLR model.

#5 -Tuning your SQL Server 2005 database engine
Installing SQL Server 2005 is not your greatest challenge; it's ensuring that the new DBMS meets high-performance demands of your business and IT departments. Learn how to tune your new system using the Database Engine Tuning Advisor.

#6 -SQL Server 2005 backward compatibility issues to consider
Do you fear a SQL Server 2005 upgrade will break server applications? Windows expert Serdar Yegulalp addresses key backward compatibility problems you may encounter.

#7 -SQL Server 2005: 10 steps to justify and plan your upgrade
Your decision to upgrade to SQL Server 2005 may come down to upgrade cost and time versus business improvement and competitive advantage. Follow these 10 steps to help you determine if an immediate upgrade is right for your organization.

#8 -SQL Server 2005 Upgrade Advisor reduces unknowns
SQL Server 2005 Upgrade Advisor can help you analyze your databases and server before upgrading, to give you fair warning of potential problems. Learn how to get it up and running.

#9 -Upgrade to SQL Server 2005 and maintain older database
Upgrading to SQL Server 2005 may cause you some initial trepidation. You'll want to maintain your databases in old faithful (SQL Server 2000) while your new system proves reliable. Discover methods, including replication, SQL traces and third party tools, in which to do so.

#10 -SQL Server 2005 upgrade hurdles
Before upgrading to SQL Server 2005, consider this collection of potential migration hurdles and pitfalls, from parameters that may cause blocking, to default settings that are no longer supported in the new DBMS.

#11 -Step-by-Step Guide: Migrating to SQL 2005 with Copy Database Wizard
The Copy Database Wizard offers a point-and-click interface to easily migrate a single SQL Server database and its objects from SQL Server 2000 to 2005. Edgewood Solutions' Jeremy Kadlec explains how in this step-by-step guide.

#12 -SQL Server 2000 to 2005 upgrade checklist
Upgrading from SQL Server 2000 to 2005 involves key planning considerations. Before you upgrade to SQL Server 2005, review this checklist.

What's Hot: Top 10 new features in SQL Server 2005
In the business world, everything is about being "better, faster and cheaper" than the competition -- and SQL Server 2005 offers many new features to save energy, time and money. From programming to administrative capabilities, this version of SQL Server tops all others and it enhances many existing SQL Server 2000 features. Edgewood Solutions' Jeremy Kadlec shares his SQL Server 2005 top 10 list.

This was first published in August 2007

Dig deeper on SQL Server Migration Strategies and Planning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close