Run a script on the Digita Suite products on your network or standalone install

Before you run a script on Digita software, we recommend you make a backup of the product database with the
Digita Database Back Up Tool
on your server (if a network install) or main machine (if a standalone install).
note
The script that you get to run on your Digita products should be in a ZIP file.
  1. Download the ZIP file onto your server if you have a network installation, or onto the main machine if a standalone installation.
  2. Right-click the ZIP file, select
    Properties
    from the context menu, mark the
    Unblock
    checkbox in the Security section, then select
    OK
    .
  3. Right-click the ZIP file to extract its contents, then select
    Extract All
    from the context menu.
  4. If the extracted files contain a BAT file, take the following steps:
    note
    If the file doesn't contain a BAT file, go to step 5 to use SQL Server Management Studio to run the script.
    1. Right-click the
      RUN ME.bat
      file, then select
      Run as administrator
      .
      note
      If this doesn't work, double-click the file.
    2. If you get a Windows Security screen, select
      More info
      , then
      Run anyway
      .
    3. Select
      Yes
      .
      note
      • You'll get a screen that shows the
        rows affected
        message when Windows has finished running the file.
      • If this screen shows an error take a screenshot send it to Digita Support. If you've just run the script as an administrator, try to double-click the BAT file
  5. If there's no BAT file in the extracted files, you'll need to take the following steps to run the script with SQL Server Management Studio:
    1. Make sure all users are signed out of the application.
    2. Make a backup of the database.
    3. If you don't have SQL Server Management Studio, download it from Microsoft.
    4. Once you've selected the relevant database you can select
      Execute
      to run the script
      note
      The screen will show how many rows were affected, which lets you know if it successfully ran.
      The options in the dropdown list relate to the following Digita products:
      • AccountsPro
        : Accounts Production. 
      • AccountsProduction
        : Accounts Production Advanced.
      • CoSecPro
        : Company Secretarial.
      • CoTaxSA
        : Corporation Tax.
      • PracticeManagement
        : Practice Management.
      • TaxyWin
        : Personal Tax.

Related content