 |
 |
| SQL Server Tips: |
|
 |
 |

MICROSOFT SQL SERVER
Compatibility of SQL Server 2005 and 2000 coexisting
By Michelle Gutzait 07.02.2007
Rating: -3.33- (out of 5)




|
So, you've decided to upgrade your databases from SQL Server 2000 to SQL 2005.
A lot has been said as to why upgrade: gaining scalability, reliability, up to 30% performance improvements and much more.
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
|


');
// -->
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.
|
 |
|
|
 |
|
 |
 |
 |
 |
| TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of . |
|
| | |
All Rights Reserved, , TechTarget |
|
|
|
|
|