225 pts.
 SQL 2000 to Yukon Migration
Posted on behalf of Kilaru: We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of the applications while other applications continue using SQL 2000. If so, can you please tell me the procedure for the same.

Software/Hardware used:
ASKED: August 8, 2007  9:32 AM
UPDATED: May 23, 2008  5:37 PM

Answer Wiki:
Yes it is. When you do this be sure to not upgrade the existing SQL Server 2000 instance. You will want to install SQL Server 2005 as a named instance then migrate only the databases you want to, into the names instance.
Last Wiki Answer Submitted:  May 23, 2008  5:36 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,505 pts.