Migrating data from SQL Server 6.5 to SQL Server 2005

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • info.nrieger@web.de
    #1

    Migrating data from SQL Server 6.5 to SQL Server 2005

    Hello,

    I'm not very familiar to SQL Server, but I've to upgrade a DBMS from
    V6.5 to V2005.
    >From the V6.5 I've got a backup file and a dump file (which seems to be
    the same, at least it has the same size).

    After installing V2005 - at another system - I could not find any
    option to import a database from an old system, e.g. importing/reading
    a dump file, backup file.

    How can I migrate the data from V6.5 to V2005 ?

    Is there a way to make an export - like in informix - which creates a
    sql script including all data and definitions (all tables,views, stored
    procedures, users, etc.) ?

    Or can I connect directly V2005 to V6.5 and import the database this
    way ?

    Any help is appreciated.

    Thanks a lot in advance.

    Norbert

    Tags: None
    • Erland Sommarskog
      #2
      Re: Migrating data from SQL Server 6.5 to SQL Server 2005

      (info.nrieger@w eb.de) writes:
      I'm not very familiar to SQL Server, but I've to upgrade a DBMS from
      V6.5 to V2005.
      >
      >>From the V6.5 I've got a backup file and a dump file (which seems to be
      the same, at least it has the same size).
      >
      After installing V2005 - at another system - I could not find any
      option to import a database from an old system, e.g. importing/reading
      a dump file, backup file.
      >
      How can I migrate the data from V6.5 to V2005 ?
      There is only one tool in this world that can read a backup file from
      SQL Server 6.5 and that's SQL Server 6.5. SQL Server underwent a complete
      architecture change from 6.5 to SQL7, that's why. (Had you had a
      backup from SQL 7, you could just have restored it on SQL 2005.)

      So how do you get SQL 6.5? It used to be available on MSDN Subscriber
      Downloads. I would expect that it still is, but it was a while since
      I visited that site.

      If you don't have an MSDN subscription that gives you access to downloads,
      I suggest that you contact your local Microsoft office.

      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        Previous template Next
        Working...