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

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 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.  Note that this only has to be ran once per database location and not on every install.  Now simply close the SQLDataUpdater.exe application.  Open the AccuSQL 2019 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 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, ...

    • 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, ...

    • AccuTrack/AccuSQL: How can I check for software updates in the software?

      To check for software updates in AccuTrack or AccuSQL simply do the following: Login to AccuTrack or AccuSQL as an Admin from the Sign-in Screen: Once logged in, click the Database option on the right-side menu.  And then in the middle click the ...