Summary

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

Details

Page properties

Parent

...	...	@@ -1,1 +1,1 @@
1		-xwiki:technical-documentation.analysis.sql.WebHome
	1	+technical-documentation.analysis.sql.WebHome

Content

...	...	@@ -8,6 +8,7 @@
8	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	9	** [[https:~~/~~/learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download>>https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download]]
10	10	** C:\Program Files\Microsoft SQL Server\160\DAC\bin
	11	+* turn off real time scan (anti virus)
11	11
12	12	1. run extract with [[sql-script-db.ps1>>doc:technical-documentation.Source Control.migration.sql.sql-db-export.WebHome]] with validate set to true and raw objects set to true, only need tbl-triggers, functions and sp
13	13	11. reason for this is to identify any procedure/triggers/functions that dont compile
...	...	@@ -21,7 +21,7 @@
21	21	1. run dacpac publish to managed instance
22	22	1.
23	23
24		-= =
	25	+= =
25	25
26	26
27	27
...	...	@@ -29,6 +29,34 @@
29	29
30	30	* no encrypted objects, they need to be decrypted or removed prior to exporting.
31	31
	33	+
	34	+SQL 2012
	35	+
	36	+
	37	+
	38	+EXEC sp_configure 'show advanced options', 1;
	39	+GO
	40	+RECONFIGURE;
	41	+GO
	42	+
	43	+EXEC sp_configure 'xp_cmdshell',1
	44	+GO
	45	+RECONFIGURE
	46	+GO
	47	+
	48	+
	49	+EXEC XP_CMDSHELL 'net use O: ~\~\zagpebslab.file.core.windows.net\sqlshare /user:"localhost\zagpebslab" "access_key"'
	50	+
	51	+EXEC XP_CMDSHELL 'Dir O:'
	52	+
	53	+
	54	+BACKUP DATABASE Everest_TEST
	55	+TO DISK = N'O:\ENS_Everest_Test_20230721_1806.bak'
	56	+WITH COMPRESSION;
	57	+GO
	58	+
	59	+
	60	+
32	32	= Importing =
33	33
34	34