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 :)

Database Migration

Hello All,
I need to migrate our databases from one server to another. Now since these
databases have DTS packages/scheduled jobs associated with them, should i
just restore the MSDB database on the target server to recover all settings?
Or is there any alternate way that will be best for my scenario?
Thanks
MannyI would script the job (right-click in EM). And Save DTS packages as files and from those files open
and save them in the new instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Manny Chohan" <MannyChohan@.discussions.microsoft.com> wrote in message
news:70B7B8A8-DC90-4C7E-B484-B88EABD23F92@.microsoft.com...
> Hello All,
> I need to migrate our databases from one server to another. Now since these
> databases have DTS packages/scheduled jobs associated with them, should i
> just restore the MSDB database on the target server to recover all settings?
> Or is there any alternate way that will be best for my scenario?
> Thanks
> Manny