What do i do first on my MSSQL 2000 before moving to 2005

Discussion in 'Databases' started by henry_nguyen, Apr 10, 2009.

0
  1. #1
    HI,

    What do i need to do first with my database on MSSQL 2000 before moving to MSSQL 2005?

    I heard so many people told me to do detach/atttach or backup and stuff but I really dont understand what i need to do first.

    Please help
     
    henry_nguyen, Apr 10, 2009 IP
  2. qazu

    qazu Well-Known Member

    Messages:
    1,834
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    165
    #2
    Always backup first.
     
    qazu, Apr 10, 2009 IP
  3. henry_nguyen

    henry_nguyen Well-Known Member

    Messages:
    710
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    130
    #3
    backup to what kind of file? backup to mdf or access?
     
    henry_nguyen, Apr 10, 2009 IP
  4. qazu

    qazu Well-Known Member

    Messages:
    1,834
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    165
    #4
    No, backup to a .bak file.
     
    qazu, Apr 11, 2009 IP
  5. harpreetjuit

    harpreetjuit Peon

    Messages:
    200
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #5
    USe import export utility and you can back up your data in an excel file.
    later while setting up a new database load this CSV file :)
     
    harpreetjuit, Apr 13, 2009 IP