To determine the version of your database you should execute the following command:
Query Database Engine Version |
Copy Code
|
---|---|
SELECT @@VERSION; |
The return will look something like this:
VistaDB 6.0.0 - Build 6.0.0.1 for .Net 4.5.1 Copyright (C) 2009-2019 Gibraltar Software, Inc. All rights reserved.
There are several parts to the database engine version -
Part | Means |
---|---|
VistaDB 6.0.0 |
The TSQL Version of the engine - this indicates the specific TSQL Language dialect and file format used by the engine. This version can be used to identify whether or not a particular feature is supported by the engine. |
Build 6.0.0.1117 |
The file version of the VistaDB engine. This uniquely identifies a specific build of VistaDB which is for use when checking against VistaDB release notes. |
for .Net 4.5.1 |
The minimum version of .NET the engine requires. |
If your database is out of date and requires a pack the engine will throw an exception at the time the database is opened with a message:
Database specification changed. Pack database to update
Packing the database will update the internal structures to the most current version.