2000 to 2005 1

[dbomrrsm]

We have a number of databases that we need to move from 2000 to 2005.

I belive this can be done using the restore database T/SQL command from a .BAK file of the 2000 database.

Is it possible to copt the MDF file of a 2000 database and use that create the database in 2005.

If there is a better way to complete this process I would love to hear about it.

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[mrdenny]

You can do either one. I've done both. Both work just as well and should go fairly quickly.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[dbomrrsm]

mrdenny

Thanks for the reply.

How would you go about using the MDF file to carry out this operation - would you use the restore command or is it different.

Many thanks.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[mrdenny]

When using the MDF and LDF just do an attach database using the GUI or the sp_attach_db procedure. SQL will take care of the rest.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[dbomrrsm]

mrdenny

Excellent - thanks very much for the advice.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]