Home > IT Answers > Security > SQL 2000 to Yukon Migration
Kilaru
0 pts.
0
Q:
SQL 2000 to Yukon Migration
Security, Oracle, SQL, Servers, Microsoft Windows, DB2, Management, Database, OS, Desktops, 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.
ASKED: Jul 25 2007  8:02 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Oct 5 2007  8:18 PM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   47070 pts.  |   Feb 22 2008  5:00AM GMT

How did your database migration go? Were you able to get it completed?

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

 
0