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,6 +1,13 @@ 1 1 * compressed file 2 2 * contains ddl and dml data 3 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 4 4 5 5 = = 6 6 ... ... @@ -8,8 +8,20 @@ 8 8 9 9 * no encrypted objects, they need to be decrypted or removed prior to exporting. 10 10 11 - 12 12 = Importing = 13 13 14 14 15 15 = Modifying and Troubleshooting = 22 + 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> 26 + 27 + 28 +== Recalculate Signature == 29 + 30 +* incubator/ebsphere.crm/ebs-devops-devops-sql/calc-signature-bacpac.ps1 31 +* modify Origin.xml 32 +** Checksum attribute for model.xml 33 + 34 +