Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, tutorials, and more.

To Migrate or Upgrade?

Obviously, the Upgrade Advisor is useful only if you have existing SQL Server databases. But if you have existing databases, you should first consider whether it is better to upgrade or to install a new instance for SQL Server 2005 and then migrate the existing data to the new SQL Server. Each choice has its advantages. With either choice, you’ll run the same Setup.exe application; during the setup process, you will indicate whether you want to install a new SQL Server or upgrade an existing SQL Server.

Migrating

To migrate a database from an existing SQL Server instance (called the source) to SQL Server 2005 (the destination), you’ll need to choose the option to install a new SQL Server, and as a follow-up, you will move ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.