How to transfer an SQL SERVER database

I am using SQL server 6.5. (I am a newbie.) I want to change the server that was originally stored in the database. How can I transfer it? The book at hand is different from my operation interface, which makes me angry! My basic idea is as follows: Back up the database first ---- *. dat file-set the device, database, and table on another machine (Set *. SQL file using isql to generate table structure) --- restore with restore (the table content should be restored ).
In the last step, the restore button is always unavailable. I don't know how to solve the problem. Please help me !!!
Azury (from 202.111.130.166) is attached to the SQL database at 11:58:10 am from 99 to 5-19:
1. Do not change the original database server.
2. reinstall an SQL Server.
3. After the installation is complete, image the two servers in Enterprise manager
(Actually, there are two Register servers)
3. Select the database to be transferred
4. Select Tools> Database Backup/Restore from the menu.
5. Set Source/target and other parameters
6. Transfer (very fast)
Try it.
:)
Lucy (from 202.111.130.166) was added to the SQL database at 11:56:52 am from 99 to 5-19:
Then copy all the original directories to overwrite the existing files.
However, I also heard that I have never tried it. azury may have a better method, but her method may make some data errors.
Xiao lazy (from 202.111.130.166) was added to the SQL database at 12:00:54 PM from 99 to 5-19:
Choose TOOL-DATABASE/object transfer from the menu in enterprise manager.
Select the original SQL server and database as source
Destination is your current server and database
Visitor (from 210.72.252.34) is attached to the SQL database at 04:16:49 PM from 99 to 5-19:
MS has many problems when it is upgraded from 6.5 to 7.0.
Call their engineers,
So far, we have not provided a simple and reliable solution.
If not,
Let's start from scratch on 7.0!