How can I move the Store Operations database to a new server

Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.

At the Old Server:

Open Store Operations Administrator

Select File, Configuration from the menu bar

Select the Register tab, note the Register number, and click Cancel

Select File, Connect from the menu bar

Click OK

Select Database, Backup from the menu bar

Specify a file name and save location for the backup file. Verify the backup file is on the network where it can be accessed from the new server.

Note: In step 9 of the connecting RMS to the MSSQL Engine and creating a new database section, browse to the backup file created above instead of the sample database file.

If attaching the dongle to the new server, shut down the new server, attach the dongle, and restart the server

Open Store Operations Administrator

Select File, Configuration from the Menu bar

Select the Register tab and enter the register number noted from the old server above

Click OK

At each workstation:

Open Store Operations Administrator

Select File, Configuration from the menu bar

Select the Database tab and enter the new Server name, Database, User name and Password

Click Test Connection

If it connects successfully, click OK

Note: These instructions assume that the Reports, Receipt templates, and Store logo are saved on the local workstations. If they are stored on the server, then these paths must be adjusted at each workstation in Configuration on the Register, Paths and Templates tabs.