Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008

    Unanswered: migration from 2000 to 2005 issues/tips

    Hi all..!!

    this is my first posting in this forum and I registered since it is very informative and active...

    I am looking for pointers to go ahead with migration of DB/DTS from 2000 to 2005.

    Any gurus in this forum who can point me any existing links or any info will be highly appreciated..


  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Take a backup of your 2000 database, saving the mdf/ndf/ldf files to a shiny new location. Then you can restore these files to your 2005 SQL Server. Note that this method will keep the 2000 compat level (80?) (beautiful thing, backwards compatibility).

    As for DTS, you can import them into 2005; they fall under management > legacy > DTS. Note that you cannot make changes to imported DTS packages as they have been deprecated from the 2005 build and replaced by something called SSIS.

    Heck, will some guru point out the flaws in what I'm saying please; something just doesn't feel right
    Home | Blog

Posting Permissions

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