Changes for page migrate to managed instance
Last modified by Rudi Marais on 2024/03/28 18:51
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,9 +1,13 @@ 1 1 * compressed file 2 2 * contains ddl and dml data 3 3 * doesnt support encrypted objects 4 -* [[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]]5 -* [[https:~~/~~/learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download>>https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download]]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 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 7 7 8 8 = = 9 9 ... ... @@ -16,7 +16,11 @@ 16 16 17 17 = Modifying and Troubleshooting = 18 18 23 +* Get-FileHash 'C:\temp\lfs\LifeSense_Everest_Test2-2023-5-17-7-37\model.xml' 24 +** place in Origin.xml 25 +*** <Checksum Uri="/model.xml">DEADD2734B789135ED627061A385FC2C1096718A7D3398658DF9097196C1F571</Checksum> 19 19 27 + 20 20 == Recalculate Signature == 21 21 22 22 * incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1