Wiki source code of bacpac
Version 2.4 by Rudi Marais on 2023/05/18 18:35
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | * compressed file |
| 2 | * contains ddl and dml data | ||
| |
1.2 | 3 | * doesnt support encrypted objects |
| |
2.3 | 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]] |
| |
2.4 | 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 | ||
| |
1.1 | 9 | |
| 10 | = = | ||
| 11 | |||
| 12 | = Exporting = | ||
| 13 | |||
| |
1.2 | 14 | * no encrypted objects, they need to be decrypted or removed prior to exporting. |
| |
1.1 | 15 | |
| 16 | = Importing = | ||
| 17 | |||
| 18 | |||
| |
1.3 | 19 | = Modifying and Troubleshooting = |
| |
2.2 | 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 |