Migrating data from SQL Server 6.5 to SQL Server 2005

[info.nrieger]

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

[Erland Sommarskog]

(in**********@web.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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx