Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: 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 Jha

  2. #2
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    Use Import and Export Data from SQL 2000

    It works

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    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_...04/28/477.aspx
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by pootle flump
    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_...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
    Have you hugged your backup today?

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by 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
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •