How to get the version number from a DACPAC file

Question

I generate DACPAC files from automated builds with a generated version number. While useful during sqlpackager operations I need to be able to determine the version number of a DACPAC before doing anything with the file.

What tooling can I use (automated of course) to query the DACPAC file for its version number and description?

score 5 · Answer 1 · answered May 22 '14 at 00:11

Hey I know you found a solution but I have an alternative method that may help someone else. By referencing Microsoft.SqlServer.Management.Dac.dll and using the DacType class:

using System.IO;
using Microsoft.SqlServer.Management.Dac;

(Not entirely sure which using statements are needed - I have copied for a larger DAC helper file)

using (Stream dacPackFileStream = File.Open(this.dacPackFileName, FileMode.Open))
{
     var dacType = DacType.Load(dacPackFileStream);
     dacPackFileStream.Close();
     return dacType.Version;
}

This looks much cleaner than a xml query. Could you add where to acquire these assemblies from? Nuget perhaps? — BozoJoe, Apr 13 '16 at 22:20

score 3 · Accepted Answer · answered May 17 '13 at 19:25

3

DACPAC files are actually zip files. Extract the zip and query the file DacMetaData which is a xml file. Use the XPath: /DacType/Version

answered May 17 '13 at 19:25

BozoJoe

6,117
4
44
66

How to get the version number from a DACPAC file

2 Answers2