I am using SQL server 6.5 (I just started using it, I am a newbie). The server where the database is originally stored needs to be replaced. How can I transfer it? The operating interface of the book on hand is different from mine, which makes me angry! My basic idea is this: Back up the database first----have the *.dat file---set up the device, library, and table on another machine (use the *.sql file to use isql to generate the table structure)--- Use restore to restore (should restore the contents of the table).
I can achieve the last step, but the restore button never lights up. I wonder if my thinking is wrong. How should I solve the problem now? Please help me! ! !
azury (from 202.111.130.166) posted on SQL database at 11:58:10 am on 99-5-19:
1. Do not move the original database server.
2. Reinstall a Sql Server server.
3. After the installation is completed, image both servers in Enterprise manager
(Actually, there are two Registers)
3. Select the database to be transferred
4. Select Tools in the menu -- > Database Backup/Restore
5. Set source/destination and other parameters
6. Make transfer (very fast)
Try it out.
:)
Lucy (from 202.111.130.166) posted in SQL database at 11:56:52 am on 99-5-19:
Then copy all the original directories over and overwrite the existing ones. The file is fine
But I have heard about it and haven’t tried it. Sister azury may have a better way, but her method may cause some errors in the data
Xiao Lazy (from 202.111.130.166 ) Posted in SQL database at 12:00:54 pm on 99-5-19:
In the menu of enterprise manager--TOOL--DATABASE/OBJECT TRANSFER
Select the original sql server server and library as source
destination is your current server and database
visitor (from 210.72.252.34) posted on SQL database at 04:16:49 pm on 99-5-19:
Problem when upgrading MS from 6.5 to 7.0 Duoduo.
I called their engineers, but
so far they haven’t been able to provide a simple/reliable solution.
If it’s not possible,
let’s start from scratch on 7.0!