Question

SQL 2000 to Yukon Migration

Database, Oracle, DB2, SQL, Microsoft Windows, OS, Servers, Security, Desktops, Management, Access, SQL Server

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.

Thanks in advance.

You would either need to setup a new server running SQL 2005, or install a SQL 2005 instance leaving the SQL 2000 instance. Then detach the databases from the SQL 2000 instance and attach them to the SQL 2005 instance.

Be sure to do full testing to make sure that there won't be any issues with the databases moving to SQL 2005 BEFORE actually moving the production database.