Home > IT Answers > SQL Server > Moving .MDF files from SQL Server 2000 to 2005
SQL Server Ask the Experts
2,585 pts.
 Moving .MDF files from SQL Server 2000 to 2005
.MDF files, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server 2005 migration
Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005 installed. Will this work?

Software/Hardware used:
ASKED: June 12, 2009  4:49 PM
UPDATED: June 14, 2009  6:04 AM
RELATED QUESTIONS
Answer Wiki:
Yes. You can detach the database from the SQL 2000 server using the sp_detach_db system stored procedure. Them copy the files to the SQL 2005 server, then attach the database using the sp_attach_db system stored procedure.
Last Wiki Answer Submitted:  June 14, 2009  6:04 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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