• compressed file
• contains ddl and dml data
• doesnt support encrypted objects
• cant have any stored procs with string that contain $( character sequence reserved sequence
  • break up sequence ie 'test$(test' become 'test$' + '(test'
• https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import
• sqlpackage
  • https://download.microsoft.com/download/7/c/8/7c877288-a0d9-4d22-b1dc-2086e262d82f/x64/DacFramework.msi
  • https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download
  • C:\Program Files\Microsoft SQL Server\160\DAC\bin

Exporting

• no encrypted objects, they need to be decrypted or removed prior to exporting.

Importing

Modifying and Troubleshooting

• Get-FileHash 'C:\temp\lfs\LifeSense_Everest_Test2-2023-5-17-7-37\model.xml'
  • place in Origin.xml
    • ​​​​​​​​​​​​​​<Checksum Uri="/model.xml">DEADD2734B789135ED627061A385FC2C1096718A7D3398658DF9097196C1F571</Checksum>

Recalculate Signature

• incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1
• modify Origin.xml
  • Checksum attribute for model.xml