I'm not very familiar to SQL Server, but I've to upgrade a DBMS from
V6.5 to V2005.
Quote:
Originally Posted by
>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(info.nrieger@.web.de) writes:
Quote:
Originally Posted by
I'm not very familiar to SQL Server, but I've to upgrade a DBMS from
V6.5 to V2005.
>
Quote:
Originally Posted by
>>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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
