AdventureWorks schema export fails DACPAC XSD validation #604
Description
- SqlPackage or DacFx Version: 162.4.92.3
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms): Azure SQL Database
Steps to Reproduce:
- Create an Azure SQL DB initialized with the AdventureWorks schema
- Run
sqlpackage /Action:Exportto export this DB to a BACPAC file locally. - Download the DACPAC XSD file locally from here.
- Perform XML schema validation of the above BACPAC file's model.xml against the above XSD file.
- XML Schema validation must pass. However it fails:
xmllint --noout --schema dacpac.xsd ./backup-db/model.xml
./backup-db/model.xml:608: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:608: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:699: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:699: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:755: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:755: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:820: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:820: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:915: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:915: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:946: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:946: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:4338: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:4338: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:4479: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:4479: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:4634: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'QuotedIdentifiers': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml:4634: element Value: Schemas validity error : Element '{http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02}Value', attribute 'AnsiNulls': 'True' is not a valid value of the atomic type 'xs:boolean'.
./backup-db/model.xml fails to validate
Instructions to install the xmllint tool for performing this validation using apt package manager:
sudo apt-get install libxml2 libxml2-utils
Did this occur in prior versions? If not - which version(s) did it work in?
(DacFx/SqlPackage/SSMS/Azure Data Studio)