Manage Learn to apply best practices and optimize your operations.

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 last published in October 2007

Dig Deeper on SQL Server Migration Strategies and Planning

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.