|
|
Posted by Erland Sommarskog on 09/21/06 21:42
(info.nrieger@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, esquel@sommarskog.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
Navigation:
[Reply to this message]
|