bacpac
Version 2.6 by Rudi Marais on 2023/05/19 02:36
- 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
Recalculate Signature
- incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1
- modify Origin.xml
- Checksum attribute for model.xml