Update a SQL Server Database
Update an Ape Software SQL Server Database
Use these instructions to update the database structure of a Calibration Control (our Calibration Management Software) database installed on a SQL Server 2012 or higher.
Before beginning, open SQL Server Management Studio and sign in to a SQL Server as a SYSTEM ADMIN because you'll require enough permissions to create and update databases and their objects. Otherwise, your IT Group may need to perform the update.
All of the SQL files needed to update the database reside in the SQL Tools folder under the CC program folder located at Program Files\Ape Software\Calibration Control.
Before attempting to update an apecal database protect your database with a backup by right-clicking on the database, selecting Tasks, and then selecting Back Up.
Follow along with our Backup/Restore SQL Server Database help topic for more detailed instructions.
Determine the current database structure version by selecting records from the dbo.tblDBVersion_DO_NOT_EDIT table. There should only be one record.
If you do not have a StructureVersion field in the file name, use the following table as a guide to interpret the dbo.tblDBVersion table and how to choose the appropriate sql_update SQL file to begin with:
Apply the sql_update SQL files in their sort order beginning with the version indicated by the DbVersion table (above). For example, if the Rev field of your database equals 7.0.1, then begin with file sql_update_04 (pgm ver 7.0.1 to 7.2.0).sql (update from 7.0.1 to 7.2.0). If the DatabaseVersion equals 24, then begin with sql_update_10 (db ver 24 to 30).sql (file 10).
Open each file with SQL Server Management Studio and click the [! Execute] button to apply the changes until you finish with the final SQL file. Note: Ensure that none of the text in the SQL file is highlighted when the [! Execute] button is pressed because this will run only the highlighted text.
Last Updated: 27 October 2020