Moving to new PC

  • Thread starter Thread starter Doug Gordon
  • Start date Start date
D

Doug Gordon

OK, my PC is coming off lease and IS will be installing a new one for me
soon. (I hate this process: it takes me about two full days plus a couple of
weeks of futzing to get everything installed and back to working the way I
want it after starting over with a clean PC!) Anyway, I'll have to install
the XPE kit on the new PC, including the database server, but what should I
do about the database & repositories that I have on my current PC? Are there
any shorcuts to moving a database like this, or should I just try to
recreate it from scratch by applying my components and any QFEs that I have
installed?

I can't wait to load up my target .slx file and try to build it with a
re-created database :-). Arghhh!

Doug Gordon
 
Hi Doug,

If you are using Windows XP.
Try copying all files to other HDD using backup utility from windows. Or
some other copy method that will preserve access rights, and file streams.

To my knowledge Win XP is very resilient to hardware changes. So it should
continue to work only WPA can make you some difficulties.

Best regards,
Slobodan
 
Doug,
There is a way around this if you're familiar with SQL's Enterprise Manager,
I've done it many times, though it's probably not technically support - so
if you don't know what you're doing - you're on your own.

On the old machine, in Enterprise manager, "Detach" the MantisSQL DB. After
it's detached, copy it to your share or new PC. Save a copy of this in case
you hose things you can still revive the data.

Copy off any new reps that you had created during your development on the
old box.

Install full XPe tools/db onto the new machine. Detach that MantisSQL DB on
the new machine. Delete the MDF/LDF, replace it with the ones you copied
off.

Now "Attach" the old MDF/LDF from the old machine. Copy over those reps to
the same relative location under the "Repositories" share.

If the machine name remained the same from the old box to the new box you
probably don't to do anything more. If the machine name DID change, you'll
need to update the following in the XPe tool Database Manager"
- update the server name that the tools connect to.
- update the repository root for the new machine name (delete the old rep
root)
- update the repository paths to the new machine name

All in all this process takes about 10 minutes, due to having to copy over
the 500MB MDF. Note that you really don't need the LDF if you don't require
the Transaction history, if attaching the DB to the new machine it complains
about no LDF, ignore it and continue, it'll work but there won't be a
transaction log (not sure it'll work anyways since you're hacking the
machine here anyways!).

Note that the DB's MDF is where the Repository information and shares
locations are stored, so it will retain the information of the OLD machine
name and the OLD rep locations.

Andy
 
Back
Top