Moving .MDF files from SQL Server 2000 to 2005
Home > IT Answers > SQL Server > Moving .MDF files from SQL Server 2000 to 200...
SQL Server Ask the Experts
2445 pts.
0
Q:
Moving .MDF files from SQL Server 2000 to 2005
.MDF files, SQL Server 2000 migration, SQL Server 2005 migration, SQL Server 2000, SQL Server 2005
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?
ASKED: Jun 12 2009  4:49 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47440 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jun 14 2009  6:04 AM GMT by Mrdenny   47440 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0