473,395 Members | 1,613 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

SQL7 Desktop


I am trying to move a database created in ms sql7 Desktop on a win nt4
workstation, to a ms sql7 server on a win nt4 server. All service packs
are the same.

I have tried backing up the database and restoring to the sql7 server.
The restore aborts, because it recognizes the database is not from that
server. I have tried exporting, but everything does not get moved. I
have yet to try sp_detach db, I will try it this weekend.

I am trying to get any and all information on sql7 desktop and moving a
database to an sql7 server before this weekend.

Any suggestions, or reference locations would be appreciated. I already
have this reference:
http://support.microsoft.com/?id=314546
Thanks

Tim
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #1
0 1553

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Peter L.S. Trevor | last post by:
I just got Visual Studio 6 Enterprise which includes SQL Server 7. However, when I try to install SQL7 (Standard Edition ?) on Windows XP Home it only installs the client components and not...
1
by: John Gill | last post by:
We are trying to import data from a sql 7 machine into sql 2000 using import wizard in DTS. One of the tables has in excess of 80 million rows. The first time we did this it worked fine no...
1
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views...
3
by: Nick | last post by:
Im trying to access a sql200 database from a sql7 hosted stored procedure and this is not working. I know that SQL7 is not compatible with the MDAC for SQL 2000. Does anyone know if this is what is...
3
by: Jeff | last post by:
I have a SQL7 database that was installed as case-insensitive. /* Sort Order = 52, Case-insensitive dictionary sort order. */ This database contains a table that has a varchar column which...
0
by: FAS | last post by:
HOW can I create an SQL7 database by creating a file size and location first. I remember creating an SQL7 database by first creating a file size and location a while back. I am trying to do the same...
0
by: FAS | last post by:
My C: drive crashed, I have my SQL7 data and file in F: Drive. Now I have replaced my C: drive, but not able to reconnect SQL7 to the files in F drive. Please can some one help? :mad:
0
by: MALIK771 | last post by:
write now i am using SQL7 with .net 2002. on XP. and SQL server with .net 2002 on server2000 but i don't have idea about MYSQL. could u tell me the diffrence between them.
0
by: nemo12 | last post by:
Hi, I am sa on some SQL servers. My new job is transfer databases based on old SQL 7 to new servers based on SQL 2005. Yes, SQL 2005 knows the old format of MDF files. I can transfer all user...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.