Database Migration

Hi,
How do i migrate my DataBase From sql serevr 2000 to 2005? Including the data. In 2000, it was easy through DTS (Copy SQL Server Objects Task: undefined). But don't any thing of that type in 2005(SSIS). Kindly Help.........
Thanks,
Rahul JhaUse Import and Export Data from SQL 2000

It works|||I would backup & restore. I think attach\ detach works too. Why import\ export if you want to move the whole database? I can understand if you want move a subset of it...

Read & absorb:
http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/28/477.aspx
:)|||I would backup & restore. I think attach\ detach works too. Why import\ export if you want to move the whole database? I can understand if you want move a subset of it...

Read & absorb:
http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/28/477.aspx
:)

I have done both backup/restore and detach/attach. Either of those will work just fine (though I think you lose database diagrams).

I don't like export/import; I've had too many bad experiences with it.

Regards,

hmscott|||I have done both backup/restore and detach/attach. I couldn't remember if we did this when we had 2k and 2k5 machines. We are 100% 2k5 now so I couldn't test either. Thanks for the clasification :)