Compatibility of SQL Server 2005 and 2000 coexisting

You have your desktop or your testing environment with an already installed instance of SQL Server 2000 and you want to try the in-place upgrade or maybe you just want to install a new instance of SQL Server 2005. This article highlights issues that may arise when installing the new instance and also analyzes options for interaction between the two versions, such as: linked servers, multi-server administration and log shipping.

Part 1: Installing SQL Server 2005 on a SQL 2000 machine

Part 2: SQL Server 2000 and 2005: Six compatibility concerns

ABOUT THE AUTHOR:

Michelle Gutzait works as a senior database consultant for ITERGY International Inc., an IT consulting firm specializing in the design, implementation, security and support of Microsoft products in the enterprise. Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant. For the last 10 years, she has worked exclusively with SQL Server. Her skills include SQL Server infrastructure design, database design, performance tuning, security, high availability, VLDBs, replication, T-SQL/packages coding, and more. Copyright 2007 TechTarget

Rate this Tip To rate tips, you must be a member of SearchSQLServer.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT Microsoft SQL Server Tuning SQL Server performance via disk arrays and disk partitioning Should you upgrade to SQL Server 2005 or SQL Server 2008? SQL Server data conversions from date/time values to character types Using full-text search for symbols in SQL Server Monitor database mirroring and replication after a SQL Server upgrade Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005 How to configure Database Mail in SQL Server 2005 to send mail Upgrade live applications to SQL Server 2005 for high availability How to use rank function in SQL Server 2005 SQL Server high availability when upgrading to SQL Server 2005 SQL Server installation How to create a SQL Server linked server to DB2 Tuning SQL Server performance via disk arrays and disk partitioning Virtual database storage for SQL Server: Friend or foe? Tutorial: Migrating to SANs from local SQL Server disk storage How to restore SQL Server database to transition server during upgrade Storage area network (SAN) basics every SQL Server DBA must know Tips for moving from SQL Server local disk storage to SANs SQL Server 2005 log shipping setup using the wizard SQL Server tools don't appear in menu after SQL Server 2005 install Troubleshoot SQL Server 2005 SP2 installation error SQL Server installation Research SQL Server integration/interoperability How to create a SQL Server linked server to DB2 Top 10 SQL Server Integration Services (SSIS) and DTS tips Export SQL Server data to an Excel file using SSIS and Visual Studio Performance tuning for SQL Server 2005 and Exchange running on SBS Custom VB.Net scripting in SQL Server Integration Services Can SQL Server 2000 work on Windows 2003 platform? Query to search text in old DTS packages in SQL Server? Handle slowly changing dimensions with SSIS 2005 wizard Run DTS packages within SQL Server Integration Services SQL Server Blog Watch RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary CORBA  (SearchSQLServer.com) 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.