Sthealth
SSC Enthusiast
Points: 115
More actions
March 30, 2003 at 7:33 pm
#64780
Hello there I want to know how to transfer a database in one computer to another in Microsoft SQL Server Desktop Engine (MSDE is this possible ?
Allen Cui-55137
SSC Guru
Points: 51650
March 31, 2003 at 7:32 am
#452556
MSDE comes with QA tool OSQL.EXE and use it
1. You can backup database in MSDE A and restore it into MSDE B.
2. Shutdown MSDE and copy MDF and LDF files from MSDE A into MSDE B and run sp_attach_db.
Edited by - Allen_Cui on 03/31/2003 07:33:04 AM
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply