Wiki source code of bacpac
Version 2.6 by Rudi Marais on 2023/05/19 02:36
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.5 | 4 | * cant have any stored procs with string that contain $( character sequence reserved sequence |
| 5 | ** break up sequence ie 'test$(test' become 'test$' + '(test' | ||
| |
2.3 | 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]] |
| |
2.4 | 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 | ||
| |
1.1 | 11 | |
| 12 | = = | ||
| 13 | |||
| 14 | = Exporting = | ||
| 15 | |||
| |
1.2 | 16 | * no encrypted objects, they need to be decrypted or removed prior to exporting. |
| |
1.1 | 17 | |
| 18 | = Importing = | ||
| 19 | |||
| 20 | |||
| |
1.3 | 21 | = Modifying and Troubleshooting = |
| |
2.2 | 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 |