Summary

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

Details

Page properties

Content

...	...	@@ -7,6 +7,7 @@
7	7
8	8
9	9	1. put db in readonly mode
	10	+11. stop all applicable services
10	10	11. ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
11	11
12	12	1. scale db to accetable performance ie dtus 500
...	...	@@ -30,18 +30,31 @@
30	30	11. document references
31	31	11. make sure ddl audit triggers are disabled
32	32
	34	+1. enable compresssion on applicable tables
	35	+11. tblAudit etc
	36	+
33	33	1. disable all indexes except clustered
34	34
35	35	1. run imports [parallel]
36	36	11. imports runs from smallest to largest table
37		-​​​​​​​
	41	+
38	38	1. verify record counts from pre and post
39	39
40	40	1. enable indexes
	45	+
	46	+1. deploy new ddl audit triggers
	47	+​​​​​​​
41	41	1. enable ddl trigger
42	42
43		-1.
	50	+1. run db security scripts
	51	+11. creates db groups and ad groups
44	44
	53	+1. update all settings to new environment
	54	+​​​​​​​
	55	+1. do audit table test
	56	+
	57	+1. scale db down to minimum
	58	+
45	45
46	46
47	47	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
...	...	@@ -60,9 +60,6 @@
60	60	(% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
61	61	[[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
62	62
63		-* C:\Users\alliancetest\.mssqlscripter
64		-* mssql-scripter -S "kula.database.windows.net" -d Everest_Test -U ebsadmin -P xxx -r -f E:\temp\khula_test.sql ~-~-display-progress ~-~-enable-toolsservice-logging
65		-
66	66
67	67	)))
68	68