Migrate 2000 to 2005 2

[micang]

Hi All,

I have a desktop with SQL 2000 installed and now we have a new server box with SQL 2005.

If I attach and re-attach the mdf files from my 2000 instance to a 2005 instance, will this work?

I have done reading, but can't really get a direct answer. The 2000 server has 2 databases, one is simple and just has large tables. The other database has a more complete structure as a developer is busy creating a new database.

Any help wil lbe appreciated.

Michael

 

[onpnt]

Yes that will work

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[micang]

Thanks onpnt, much appreciated.

Michael

 

[gmmastros]

You should be aware that attaching a 2000 database to a 2005 engine will automatically upgrade the database to 2005. Once you do this, you cannot 'go back' to 2000.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[micang]

Thanks George. I will keep a backup up copy of 2000 just incase.

is it as simple as that though, just copy the mdf files to the new server box and then just attach them?

Michael

 

[gmmastros]

Yes. It's as simple as that.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[micang]

Thanks for confirming that.

Michael

 

[gmmastros]

onpnt confirmed it first. maybe he desrves the star more than me?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[micang]

You're right! Stars for both!

Thanks

Michael

 

[micang]

Someone has suggested to me that for this we can also take the route of creating backups of the 2000 server databases and then restoring them to the 2005 server.

I guess there is not much difference from this as opposed to de-tach and attach the mdf's?

Many Thanks

Michael

 

[onpnt]

There are several ways you can do this. Side-by-side, backup/restore, detach/attach and on.

Your environment should dictate which is best for an upgrade. I would weigh each carefully and make sure you do the one thta is proper for your systems.

You will find all of your alternatives and pros/cons on MS site. Start here

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[micang]

Thanks onpnt. Much appreciated.

Michael