moving database

Posted by miker on January 9, 2006, 8:16 am

Please log in for more thread options

I would like to know how tomove the database we use to another computer while
we upgrade to windows xp (formating the drive) and still be able to work i
have looked in the book but it only shows how to restore..thanks

Posted by Rob on January 9, 2006, 9:30 am

Please log in for more thread options

You first need to do a manual backup of the database. Take the .bck file over
to the computer that you are going to be using in the interim. Follow the
steps on restoring the backup. Then change where the database points to in
the SO Administrator to on that computer to point locally = (local). After
changing the setting press the Test Database Connection button if it
successfully connects then try opening SO POS and SO Manager.
Then do your upgrade and reverse the steps.

Rob

"miker" wrote:

> I would like to know how tomove the database we use to another computer while

> we upgrade to windows xp (formating the drive) and still be able to work i

> have looked in the book but it only shows how to restore..thanks

Posted by Glenn Adams [MVP - Retail Mgmt on January 9, 2006, 2:17 pm

Please log in for more thread options

Don't forget that you would need to change the Server name in SO
Administrator in any other registers or workstations that you wanted to
switch to the temporary database.

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> You first need to do a manual backup of the database. Take the .bck file

> over

> to the computer that you are going to be using in the interim. Follow the

> steps on restoring the backup. Then change where the database points to in

> the SO Administrator to on that computer to point locally = (local). After

> changing the setting press the Test Database Connection button if it

> successfully connects then try opening SO POS and SO Manager.

> Then do your upgrade and reverse the steps.

> Rob

> "miker" wrote:

>> I would like to know how tomove the database we use to another computer

>> while

>> we upgrade to windows xp (formating the drive) and still be able to work

>> i

>> have looked in the book but it only shows how to restore..thanks