Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Lightbulb Unanswered: Microsoft SQL server 6.5 to 2005

    Hi Fellas,
    I would really appreciate if you could help me out with the following two questions?
    1) Can 2005 server files be converted to 6.5? and how?
    2) How easy it to upgrade from 6.5 to 2005? and how?

    I would be really grateful by your help
    Nick

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Not so easy task to do as you have to compare each and every aspect of the database to ensure they work in compatibility of SQL 2005.

    Refer to http://sqlserver-qa.net/blogs/tools/...vironment.aspx & http://sqlserver-qa.net/blogs/tools/...ql-server.aspx in this case.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2007
    Posts
    2
    Thanks a lot, i appreciate.

  4. #4
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Maverick

    I should imagine it would depend on the size & complexity of the 6.5 DB

    For a simple DB I would probably just script out the Schema then, run script & right click - import the data on the 2005 box then - suck it & see fixing any issues (IF there are any) in testing.

    Or you could spend your life reading up on the possible failures & effects that may occur as Satya suggests

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

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