Home > IT Answers > SQL Server > Manually migrating databases from SQL Server 2000 to SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Manually migrating databases from SQL Server 2000 to SQL Server 2005
SQL Server 2000, SQL Server 2005, SQL Server migration
I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

Software/Hardware used:
ASKED: September 16, 2008  6:24 PM
UPDATED: September 16, 2008  11:44 PM
RELATED QUESTIONS
Answer Wiki:
There should be no big issues that come up. Before doing the migration it is important to test the databases and client software against SQL Server 2005 in a development and QA environment to ensure that everything works as expected. Without an in depth knowledge of your database and application there's no way to know what problems you may run across.
Last Wiki Answer Submitted:  September 16, 2008  11:44 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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,505 pts.