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 directory 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.

2. 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.

3. 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.

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. 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 How to run WSSetup from the SDK folder
Scheduled reports do not run
Moving Scheduled Reports to Another Computer
A message reading "Access Denied" appears during Stonefield Query installation, and the installation is then rolled back.
A message reading "Stonefield Query is unable to create a directory for its files" appears when Stonefield Query is started.
Article details
Article ID: 25
Category: How Do I... ?
Rating (Votes): Article rated 3.4/5.0 (45)

« Go back