Pointers for SQL Server parallel upgrades

November 5, 2007

When moving from one installation of SQL Server to another, whether it's the same iteration of SQL Server or a higher revision, it helps to do things in parallel. A parallel upgrade means installing the new database product side by side -- either on the same system or on a different one -- with your existing database, and moving or copying data between the two. This sort of operation seems easy enough, but there are a couple of caveats involved, especially when doing a parallel upgrade on the same system.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280346,00.html