Multiple choice sql-server

John Doe has SQL Server 4.2 and she wants to upgrade the server, data and database objects to SQL Server 7. Which upgrade path will accomplish this goal?

  1. Just upgrade normally to SQL Server 7

  2. Use SQL 6.5 Transfer Management Tool to push the data and objects from version 4.2 to 7

  3. Upgrade the server to SQL Server 6.5, then upgrade again to SQL Server 7

  4. Use the DTS to transfer the data and objects
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Server 7.0 does not support a direct upgrade path from version 4.2. The standard procedure requires upgrading the 4.2 instance to version 6.5 first, and then using the SQL Server Upgrade Wizard to move to version 7.0.

Keep practicing — related questions