Sample Header Ad - 728x90

The store schema does not contain the Element class SqlXmlCompressionOption

0 votes
1 answer
513 views
I hope you are all good I am doing or importing a bacpac file from azure SQL to SQL on-premisse with SSMS and I am receiving this error. Somebody get me help or give me a north enter image description here Details Could not load schema model from package. (Microsoft.SqlServer.Dac) ------------------------------ Program Location: at Microsoft.SqlServer.Dac.DacPackage.LoadModel(IPackageSource packageSource, Boolean ignoreUnresolvedExternalErrors) at Microsoft.SqlServer.Dac.Extensions.DacExtensions.GetCollationString(IPackageSource packageSource) at Microsoft.SqlServer.Dac.Extensions.DacExtensions.GetCollationString(BacPackage package) at Microsoft.SqlServer.Management.Dac.DacWizard.CreateDatabaseOnTargetWorkItem.DoWork() at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run() =================================== The store schema does not contain the Element class SqlXmlCompressionOption. (Microsoft.Data.Tools.Schema.Sql) ------------------------------ Program Location: at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.ModelEntityFactory.CreateElement(String elementClassName, String nameString, Int32 line, Int32 column) at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.PossibleElementState.ReadElement() at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.ModelContentsState.ProcessStartElement() at Microsoft.Data.Tools.Schema.SchemaModel.XmlDeserializerEngine.ReadData(DeserializerState initialState, Boolean keepCurrentReaderPosition) at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.DeserializeXml(TextReader input, ErrorManager errors, String source, Action`3 constructorParametersSetter) at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.DeserializePackage(SqlPackage package, ErrorManager errors, Action`3 constructorParametersSetter) at Microsoft.SqlServer.Dac.DacPackage.DeserializePackage(SqlPackage package, DacSchemaModelStorageType modelStorageType, ErrorManager errorManager, DataSchemaModelHeader& header) at Microsoft.SqlServer.Dac.DacPackage.LoadModel(IPackageSource packageSource, Boolean ignoreUnresolvedExternalErrors) SQL on premise Version (sql server 2019) enter image description here SQL Azure Version enter image description here
Asked by Wesley Neves (11 rep)
Aug 8, 2022, 09:53 PM
Last activity: Jul 3, 2024, 11:06 PM