SQL Server 6.5 - how to transfer DB from one server to another

[MavrickStl]

Hi there,

I would like to copy a SQL server 6.5 database from one NT server to another NT server. What would be the best way to do that, so that not only it copies all the objects with data but all the other important stuff ex. user's etc.I am new to the DB world and SQL Server is my first DB experience.

Thanks,

Mav

 

[dbtech]

its been a long time since i have used sql 6.5, There is tool called as Transfer Manager if i'm not wrong, Can u check from the start menu program files, under sql server

dbtech

 

[cbuono]

Actually this is a pretty simple task. There are .dat files under \\MSSQL\data that you can simply copy to the new server.

Firstly on the new server create a new db that is the same size as the db on the old server. Once the db is created on the new server stop the SQL services. Also on the old server stop the SQL services as well. Before copying the .dat file directly over the new copy move the file out somewhere where you can get to it if you have any problems. Copy the old db to the new server start the services and you should be on your way! Obviously some dba's will say that you shouldn't do this but in SQL 6.5 I've done this over and over with no issues.


Good Luck,
Chris

 

[MeanGreen]

Jikkou01,
I have not worked with 6.5 for some time, but I recall that their may be an issue with your solution. Your solution on 6.5 will only work if you copy ALL dat files I believe, since login security is maintained within the master database. If you just copy the DAT files from the desired database, then you may loose some of the security requirements maintained within the master database.

Hope this helps.