Upgrading the AccuSQL 2020 Database from an older version of the software

Upgrading the AccuSQL 2020 Database from an older version of the software

AccuSQL: How to Run the AccuSQL Database Updater Tool on an older AccuSQL Database
Warning!  The SQLDataUpdater.exe Utility has been updated since this KB article was written and will now be included with the installers directly like shown:

However, in order to run the application you'll need to copy it into the install directory (which should be "C:\Program Files (x86)\AccuSQL2020") for the AccuSQL application before running the SQLDataUpdater.exe tool.

1.  Right-click on the AccuSQL 2020 icon and select Open file location.



2. Locate the application SQLDataUpdater.  Double click to run the SQLDataUpdater.


3.  Fill out the fields with the SQL Server connection and authentication information just the same as you would when connecting to the AccuSQL client Database Location.  Make sure to select the appropriate SQL client driver for your environment. A best practice is to select the same SQL client driver that is selected in the AccuSQL client Database Location settings. Click the Update button.


4.  Repeat this process for each database that your client computers will be connecting to on the SQL Server.
IMPORTANT:  Run this process once per database location. Keep in mind that it only has to be run once per database and does not have to be run once from every client install.  
5. Now simply close the SQLDataUpdater.exe application.  Open the AccuSQL 2020 application to ensure a successful upgrade.

    • Related Articles

    • Upgrading to AccuTrack 2019 from an Older Database

      Upgrading to AccuTrack 2019 from an Older Database The following is the recommended database upgrade procedure. You will need to follow this procedure when you upgrade your software to a higher version with a different database structure (e.g. ...
    • Upgrading the AccuSQL 2019 Database from an older version of the software

      AccuSQL: How to Run the AccuSQL Database Updater Tool on an older AccuSQL Database 1.  Right-click on the AccuSQL 2019 icon and select Open file location. 2. Locate the application SQLDataUpdater.  Double click to run the SQLDataUpdater. 3.  Fill out ...
    • Upgrading to AccuTrack 2020 from an Older Database

      Upgrading to AccuTrack 2020 from an Older Database The following is the recommended database upgrade procedure. You will need to follow this procedure when you upgrade your software to a higher version with a different database structures (e.g. ...
    • AccuSQL 2020 (Platinum) Installation Instructions

      AccuSQL 2020 (Platinum) Installation Instructions 1. Click on the HighTail link that was sent to you. And then click on the Download All button. 2. Click the Save button. 3. Right-click on the downloaded files and Extract all of the files 4. Once ...
    • AccuTrack/AccuSQL: How to Change the Database Location

      Method 1: Sign-in to the AccuSQL client as a system administrator and change the database location Step 1:      Open AccuTrack/AccuSQL and log in with Admin credentials. Now, from the right-side menu of the System Administration screen, ...