Wiki source code of bacpac
Version 2.4 by Rudi Marais on 2023/05/18 18:35
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | * compressed file | ||
| 2 | * contains ddl and dml data | ||
| 3 | * doesnt support encrypted objects | ||
| 4 | * [[https:~~/~~/learn.microsoft.com/en-us/azure/azure-sql/database/database-import>>https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import]] | ||
| 5 | * sqlpackage | ||
| 6 | ** [[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]] | ||
| 7 | ** [[https:~~/~~/learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download>>https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download]] | ||
| 8 | ** C:\Program Files\Microsoft SQL Server\160\DAC\bin | ||
| 9 | |||
| 10 | = = | ||
| 11 | |||
| 12 | = Exporting = | ||
| 13 | |||
| 14 | * no encrypted objects, they need to be decrypted or removed prior to exporting. | ||
| 15 | |||
| 16 | = Importing = | ||
| 17 | |||
| 18 | |||
| 19 | = Modifying and Troubleshooting = | ||
| 20 | |||
| 21 | |||
| 22 | == Recalculate Signature == | ||
| 23 | |||
| 24 | * incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1 | ||
| 25 | * modify Origin.xml | ||
| 26 | ** Checksum attribute for model.xml | ||
| 27 | |||
| 28 |