Summary

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

Details

Page properties

Content

...	...	@@ -26,20 +26,31 @@
26	26	1. create db
27	27
28	28	1. create schemas
29		-11. prep scripts first
	29	+11. prep scripts first remove non applicable scripting
30	30	11. document references
31	31	11. make sure ddl audit triggers are disabled
32	32
	33	+1. enable compresssion on applicable tables
	34	+11. tblAudit etc
	35	+
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		-​​​​​​​
	40	+
38	38	1. verify record counts from pre and post
39	39
40	40	1. enable indexes
	44	+
	45	+1. deploy new ddl audit triggers
	46	+​​​​​​​
41	41	1. enable ddl trigger
42	42
	49	+1. run db security scripts
	50	+11. creates db groups and ad groups
	51	+
	52	+1. update all settings to new environment
	53	+
43	43	1.
44	44
45	45
...	...	@@ -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