?
Solved

SQL 6.5 DB move SQL 7.0/2000

Posted on 2004-10-12
1
Medium Priority
?
197 Views
Last Modified: 2012-06-21
Hi experts,

I have a very typical problem. We have a SQL Server 6.5 server with databases loaded.

We recently installed Windows 2000 Advanced Server in another machine. Tried loading SQL Server 6.5 on that. But it gets hung on installation.

We tried installing SQL Server 7.0 on the same server and tried moving the database from SQL Server 6.5 using DTS wizard. It fails saying sql driver incompatibe.

I also tried backing up SQL 6.5 database but unable to restore (.dat extension).

Is there a way to atleast to install SQL Server 2000 and complete the task of database movement.

Help me vey urgent.

Prathab
0
Comment
Question by:prathab
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 10

Accepted Solution

by:
AustinSeven earned 1500 total points
ID: 12287430
This should get you on the right track...

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx


AustinSeven
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question