Stonefield Query Home > Stonefield Query Help Desk > Knowledgebase

Search help:

Moving Stonefield Query to Another Computer


Applies to:

  • Stonefield Query SDK

  • Stonefield Query for AccountMate

  • Stonefield Query for ACT!

  • Stonefield Query for Alere

  • Stonefield Query for GoldMine

  • Stonefield Query for HEAT

  • Stonefield Query for Sage 300 ERP

  • Stonefield Query for Sage Pro

Here are the steps to move Stonefield Query to another computer.

1. Take note of the current Stonefield Query settings.

Run Stonefield Query. Choose the About Stonefield Query item from the Help menu. On the About screen, there is a list of settings information about Query. The 2nd, 3rd, 4th, and 5th of these are folder locations where Stonefield Query files are stored. Take note of these locations.

Choose Options from the Tools menu. Take note of each setting on each page in this dialog (for example, take screen shots of each page).

Choose Scheduled Tasks from the Tools menu. Edit each scheduled report and take note of each setting for each schedule.

2. Back up any Stonefield Query reports.

Choose the Export All Reports item from the File menu in Stonefield Query. The program prompts for a directory for the reports to be stored. If possible, select a network location which is be available from the new installation location. Each Stonefield Query report definition is saved in the chosen directory as a file with an sfx extension.

3. Remove any existing licenses.

Open Stonefield Query and select the License Manager item from the Tools menu. All the Stonefield Query license serial numbers that have been activated for this copy of Stonefield Query are listed in the License Manager screen. For each one, take note of the serial number, then select it in the list and click the Remove button. This allows you to remove the license and displays a license removal code. Keep track of this removal code along with the serial number it corresponds to. Later, once Stonefield Query is installed in the new location, the removal code verifies that the license has been removed and a new activation can be issued.

4. Backup other files.

In addition to reports, you will likely also want to copy your users and other files. Copy the following files from the Data subdirectory of the Stonefield Query program folder:

  • Users.dbf
  • Users.cdx
  • Roles.dbf
  • Roles.cdx
  • UserRoles.dbf
  • UserRoles.cdx
  • CalcFields.dbf
  • CalcFields.fpt
  • CalcFields.cdx
  • Setup.sqs (if it exists)
  • RepProcs.prg (if it exists)

Also, copy any files in the Data\Functions folder.

DO NOT not copy the rest of the files, especially SQResource.dbf or SFQuery.lic, as these files may be out-of-date and can cause problems on the new system.

5. Uninstall Stonefield Query

Open the Add or Remove Programs applet from the Windows Control Panel. Select the Stonefield Query item in the list and click Remove. This removes the Stonefield Query program files from the machine.

6. Install Stonefield Query in the new location.

Install and set up Stonefield Query as usual, using the setup.exe program downloaded from the website.

7. Reactivate Stonefield Query.

When the new installation of Query prompts for a serial number and activation code, contact Stonefield with the information recorded in Step 2, along with the registration number from the activation screen. New activation codes will be issued.

8. Import backed up reports.

In the new installation of Query, choose the Import Reports item from the File menu. Select the sfx reports files that were created in Step 3 to restore these reports.

9. Copy the other files.

Copy the files you backed up in Step 4 to the Data subdirectory of the Stonefield Query program folder.

10. Set the options as desired.

Choose Options from the Tools menu and set the options as you noted in step 1.

11. Move or recreate scheduled reports.

See for details on moving scheduled reports. You may wish to recreate the schedules from scratch instead using the notes you took in Step 1.

12. Clean up remaining Stonefield Query items in the original location.

Some Stonefield Query files were not removed by the uninstall process in Step 4. Any files, such as reports, that were not created by the installer are not removed by the uninstaller. These files will reside in the locations noted in Step 1.

Was this article helpful? yes / no
Related articles Scheduled reports do not run
Moving Scheduled Reports to Another Computer
How to run WSSetup from the SDK folder
I deleted a report but it keeps reappearing
How do I recreate ACT!'s database views using the ActDiag tool?
Article details
Article ID: 25
Category: How Do I... ?
Rating (Votes): Article rated 3.4/5.0 (58)

« Go back