Skip to main content

How to determine Archestra/SQL versions by cab or aaPKG files

Determining Archestra Version from .cab or .aaPKG files

At the root of the .cab file or. aaPKG file you'll find a __GalaxyInfo.txt file. To get this file, rename the .cab or .aaPKG to a .zip file and then open it. Open the __GalaxyInfo.txt fle in a text editor and find a line like: CdiVersion = "3388.0127.0126.0006" - this number depends on the version of the development environment in which it was last opened.

Archestra Versions
  • IAS 2.1
    • 2.1: 2559.1144.0.0
    • 2.1 Patch01: 2559.1144.66.12
    • 2.1 Patch02: 2559.1144.77.14
  • WAS 3.0
    • 3.0: 2859.1293.0.0
    • 3.0 Patch01: 2859.1293.24.2
    • 3.0 Patch02: 2859.1293.53.4
    • 3.0 Patch03: 2859.1293.70.5
    • 3.0SP1: 2859.1293.95.15
    • 3.0SP2: 2859.1293.239.40
  • IDE 3.1
    • 3.1: 3132.57.0.0
    • 3.1 SP1: 3132.57.24.6
    • 3.1 SP2: 3132.57.91.24
    • 3.1 SP2 P01: 3132.57.103.28
    • 3.1 SP3: 3132.57.119.34
    • 3.1 SP3 P01: 3132.57.160.38
  • IDE 2012
    • 3.5: 3275.0113.0000.0000
    • 3.5 P01: 3275.113.110.8
  • IDE 2012 R2
    • 3.6: 3388.0127.0000.0000
    • 3.6 P01: 3388.0127.0126.0006
    • 3.6 Patch02: 3388.0127.0212.0011
    • 3.6 Patch03: 3388.0127.0300.0012
  • IDE 2014
    • 4.0: 3509.0148.0000.0000
    • 4.0 P01: 3509.0148.0140.0007
  • IDE 2014 R2
    • 4.1: 3735.0233.0000.0000
    • 4.1 Patch 01: 3735.0233.0223.0032
    • 4.1 SP1: 3735.0233.0399.0061
    • 4.1 SP1 P02: 3735.0233.0776.0085
  • IDE 2017
    • 17: 4148.0279.0000.0000
    • 17.1 (u01): 4545.0291.0000.0000
    • 17.2 (u02): 5019.0376.0000.0000
    • 17.3 (u03 beta01): 5414.0408.0000.0000 (beta 1)
    • 17.3 (u03 RC1): 5539.0474.0000.0000 (release candidate)
    • 17.3 (u03): 5543.0474.0000.0000
    • 17.3 (u03) SP1: 5593.0474.5686.1
  • IDE 2020
    • 20.0: 5800.0474.7005.1
    • 20.1 (R2 SP1): 6150.0474.2064.4
    • 20.1 (R2 SP1 P01): 6150.0474.4233.1

To verify the version of Archestra, under C:\Program Files (x86)\Common Files\ArchestrA\Framework\Bin open the properties of the WWCdi.dll file and compare with the version numbers above.

Determining SQL Version from .cab files

In the Database folder of the .cab file you'll find a database.backup file. To get this file, rename the .cab file to a .zip file and then open it. Extract the database.backup file from the zip file and place it somewhere on your computer.

Open SQL Server Management Studio (SSMS) and get the header information from the backup file with the following command substituting the file path as appropriate:

RESTORE HEADERONLY FROM DISK = 'C:\database.backup'
GO

This will return multiple columns but the 3 columns you need to look at and compare to the following list are:

  • SoftwareVersionMajor
  • SoftwareVersionMinor
  • SoftwareVersionBuild
SQL Server Versions
  • SQL Server 2019
    • RTM: 15.0.2000.5
    • CU8: 15.0.4073.23
  • SQL Server 2017
    • RTM: 14.0.1000.169
    • CU22: 14.0.3356.20
  • SQL Server 2016
    • RTM: 13.0.1601.5
    • SP1: 13.0.4001.0 or 13.1.4001.0
    • SP2: 13.0.5026.0 or 13.2.5026.0
  • SQL Server 2014
    • RTM: 12.0.200.8
    • SP1: 12.0.4100.1 or 12.1.4100.1
    • SP2: 12.0.5000.0 or 12.2.5000.0
    • SP3: 12.0.6024.0 or 12.3.6024.0
  • SQL Server 2012
    • RTM: 11.0.2100.60
    • SP1: 11.0.3000.0 or 11.1.3000.0
    • SP2: 11.0.5058.0 or 11.2.5058.0
    • SP3: 11.0.6020.0 or 11.3.6020.0
    • SP4: 11.0.7001.0 or 11.4.7001.0
  • SQL Server 2008 R2
    • RTM: 10.50.1600.1
    • SP1: 10.50.2500.0 or 10.51.2500.0
    • SP2: 10.50.4000.0 or 10.52.4000.0
    • SP3: 10.50.6000.34 or 10.53.6000.34
  • SQL Server 2008
    • RTM: 10.0.1600.22
    • SP1: 10.0.2531.0 or 10.1.2531.0
    • SP2: 10.0.4000.0 or 10.2.4000.0
    • SP3: 10.0.5500.0 or 10.3.5500.0
    • SP4: 10.0.6000.29 or 10.4.6000.29
  • SQL Server 2005
    • RTM: 9.0.1399.06
    • SP1: 9.0.2047
    • SP2: 9.0.3042
    • SP3: 9.0.4035
    • SP4: 9.0.5000
  • SQL Server 2000
    • RTM: 8.0.194
    • SP1: 8.0.384
    • SP2: 8.0.532
    • SP3: 8.0.760
    • SP4: 8.0.2039
  • SQL Server 7.0
    • RTM: 7.0.623
    • SP1: 7.0.699
    • SP2: 7.0.842
    • SP3: 7.0.961
    • SP4: 7.0.1063
No Comments
Back to top