Summary

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

Details

Page properties

Content

...	...	@@ -6,18 +6,53 @@
6	6	** C:\Program Files\Microsoft SQL Server\160\DAC\bin
7	7
8	8
	9	+1. put db in readonly mode
	10	+11. ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
	11	+
9	9	1. scale db to accetable performance ie dtus 500
	13	+
10	10	1. turn off real time scan (anti virus)
11		-1. run bcp extract scripts [everest & docs parallel]
	15	+
	16	+1. run bcp extract scripts
	17	+11. everest & docs parallel
12	12	11. extract run from smallest to largest table
13		-1. run schema extracts [not in parallel!]
	19	+
	20	+1. run schema extracts
	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
	25	+
14	14	1. create db
15		-1. create schema
16		-11. prep scripts first
	27	+
	28	+1. create schemas
	29	+11. prep scripts first remove non applicable scripting
17	17	11. document references
18	18	11. make sure ddl audit triggers are disabled
	32	+
	33	+1. enable compresssion on applicable tables
	34	+11. tblAudit etc
	35	+
	36	+1. disable all indexes except clustered
	37	+
19	19	1. run imports [parallel]
20	20	11. imports runs from smallest to largest table
	40	+
	41	+1. verify record counts from pre and post
	42	+
	43	+1. enable indexes
	44	+
	45	+1. deploy new ddl audit triggers
	46	+​​​​​​​
	47	+1. enable ddl trigger
	48	+
	49	+1. run db security scripts
	50	+11. creates db groups and ad groups
	51	+
	52	+1. update all settings to new environment
	53	+
	54	+1.
	55	+
21	21
22	22
23	23	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
...	...	@@ -36,13 +36,8 @@
36	36	(% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
37	37	[[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
38	38
39		-* C:\Users\alliancetest\.mssqlscripter
40		-* 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
41		-
42	42
43	43	)))
44		-* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
45		-
46	46
47	47	{{code language="sql"}}
48	48	-- index