Summary

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

Details

Page properties

Content

...	...	@@ -19,24 +19,38 @@
19	19
20	20	1. run schema extracts
21	21	11. not in parallel!
	22	+11. [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
	23	+11. C:\Users\alliancetest\.mssqlscripter
	24	+11. 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
22	22
23	23	1. create db
24	24
25	25	1. create schemas
26		-11. prep scripts first
	29	+11. prep scripts first remove non applicable scripting
27	27	11. document references
28	28	11. make sure ddl audit triggers are disabled
29	29
	33	+1. enable compresssion on applicable tables
	34	+11. tblAudit etc
	35	+
30	30	1. disable all indexes except clustered
31	31
32	32	1. run imports [parallel]
33	33	11. imports runs from smallest to largest table
34		-​​​​​​​
	40	+
35	35	1. verify record counts from pre and post
36	36
37	37	1. enable indexes
	44	+
	45	+1. deploy new ddl audit triggers
	46	+​​​​​​​
38	38	1. enable ddl trigger
39	39
	49	+1. run db security scripts
	50	+11. creates db groups and ad groups
	51	+
	52	+1. update all settings to new environment
	53	+
40	40	1.
41	41
42	42
...	...	@@ -57,13 +57,8 @@
57	57	(% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
58	58	[[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
59	59
60		-* C:\Users\alliancetest\.mssqlscripter
61		-* 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
62		-
63	63
64	64	)))
65		-* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
66		-
67	67
68	68	{{code language="sql"}}
69	69	-- index