Q

Migrating SQL Server applications after upgrade

Find how to migrate a single application to your new platform after upgrading to SQL Server 2005.

We are planning to migrate from SQL Server 2000 to SQL Server 2005 (Yukon) for one application. Right now, all the applications of the portal are mapped to the SQL Server 2000 database. Is it possible to map a single application to the SQL Server 2005 database?
It's not a matter of the number of applications. Your database is either on SQL Server 2000 or SQL Server 2005. If you only want to migrate one application you will need to make a copy of the database in order to have it on both platforms.
This was first published in October 2007

Dig deeper on SQL Server Migration Strategies and Planning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close