Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,34 +1,12 @@
1	1	* compressed file
2	2	* contains ddl and dml data
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
11	11
12	12	= =
13	13
14	14	= Exporting =
15	15
16		-* no encrypted objects, they need to be decrypted or removed prior to exporting.
17	17
18	18	= Importing =
19	19
20	20
21		-= 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		-
	12	+= Modifying =