How to move all data from SQL7 to a new machine
Posted on 2006-07-24
How can I move all the data from MsSQL7 to MsSQL 2005 Express Edition on a different machine? I have no experience with MsSQL whatsoever.
Background: A customer has a stand-alone PC (no network connection) with a Delphi application that uses MsSQL7 on the same machine (seems like overkill to me, but what do I know). The machine runs on Win2K and recently started to show signs of impending disaster (it's a Pentium II). We therefore decided to move everything to a new machine. I first tried the lazy road, ghosting the old disk and moving it to the new machine. However, since this was some kind of OEM version of Win2K, this didn't work. So I copied the application, installed BDE and MsSQL 2005 Express Edition and now I need to copy the data.