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. ...
    • 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, ...
    • AccuSQL 2019 Subscription Installation Instructions

      1. Click on the HighTail link that was sent to you. Click on the Download All button. 2. Click Save 3. Click on the downloaded files  4. Extract all the files 5. Once extracted, double click on the Folder AccuSQL 6.  Double click on the application ...