Wiki source code of bacpac
Version 2.6 by Rudi Marais on 2023/05/19 02:36
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | * compressed file | ||
| 2 | * contains ddl and dml data | ||
| 3 | * doesnt support encrypted objects | ||
| 4 | * cant have any stored procs with string that contain $( character sequence reserved sequence | ||
| 5 | ** break up sequence ie 'test$(test' become 'test$' + '(test' | ||
| 6 | * [[https:~~/~~/learn.microsoft.com/en-us/azure/azure-sql/database/database-import>>https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import]] | ||
| 7 | * sqlpackage | ||
| 8 | ** [[https:~~/~~/download.microsoft.com/download/7/c/8/7c877288-a0d9-4d22-b1dc-2086e262d82f/x64/DacFramework.msi>>https://download.microsoft.com/download/7/c/8/7c877288-a0d9-4d22-b1dc-2086e262d82f/x64/DacFramework.msi]] | ||
| 9 | ** [[https:~~/~~/learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download>>https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download]] | ||
| 10 | ** C:\Program Files\Microsoft SQL Server\160\DAC\bin | ||
| 11 | |||
| 12 | = = | ||
| 13 | |||
| 14 | = Exporting = | ||
| 15 | |||
| 16 | * no encrypted objects, they need to be decrypted or removed prior to exporting. | ||
| 17 | |||
| 18 | = Importing = | ||
| 19 | |||
| 20 | |||
| 21 | = Modifying and Troubleshooting = | ||
| 22 | |||
| 23 | |||
| 24 | == Recalculate Signature == | ||
| 25 | |||
| 26 | * incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1 | ||
| 27 | * modify Origin.xml | ||
| 28 | ** Checksum attribute for model.xml | ||
| 29 | |||
| 30 |