• 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

1. run extract with sql-script-db.ps1 with validate set to true and raw objects set to true, only need tbl-triggers, functions and sp
   1. reason for this is to identify any procedure/triggers/functions that dont compile
2. once this is done examine results and fix stored procedures on database so that they can compile, ie add missing columns or modify code to not require them
   1. repeat step 1 and 2 until you get zero objects that can't compile
3. check sql code for any reserved varables ie... and fix on DB
4. run dacpac export
   1. make sure nothing is running on source DB
   2. upgrade source DB to high level for quicker export and set back to what it was once done
   3. cmd
5. run dacpac publish to managed instance
6.  

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