how to convert db of ms sql 2005 in to 2008

Discussion in 'Databases' started by saad_sinpk, Mar 4, 2010.

  1. #1
    hi can any one tell me how i convert my data base of ms sql 2005 to ms sql 2008
     
    saad_sinpk, Mar 4, 2010 IP
  2. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #2
    i think theres a migration tool kit for mssql
     
    bartolay13, Mar 4, 2010 IP
  3. saad_sinpk

    saad_sinpk Peon

    Messages:
    85
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    what that?
     
    saad_sinpk, Mar 4, 2010 IP
  4. RonBrown

    RonBrown Well-Known Member

    Messages:
    934
    Likes Received:
    55
    Best Answers:
    4
    Trophy Points:
    105
    #4
    Are you sure you need to convert it externally? I've taken databases from SQL 2000 and SQL 2005 and copied them over to a SQL 2008 database and the database itself does the conversion. I've done this, literally, hundreds of times, and only come accross a snag twice. The problem is, once it's converted to SQL 2008 you can't convert back.
     
    RonBrown, Mar 4, 2010 IP
  5. BrianM

    BrianM Peon

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    There is no need to convert it. MSSQL 2005 databases can be attached to 2008 and run in a backwards compatibility mode.

    This is not entirely true. You can use the "Generate SQL Server Scripts Wizard" to export the data to a MSSQL 2005 compatible .sql script.
     
    BrianM, Mar 6, 2010 IP