Summary

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

Details

Page properties

Content

...	...	@@ -6,6 +6,10 @@
6	6	** C:\Program Files\Microsoft SQL Server\160\DAC\bin
7	7
8	8
	9	+1. put db in readonly mode
	10	+11. stop all applicable services
	11	+11. ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
	12	+
9	9	1. scale db to accetable performance ie dtus 500
10	10
11	11	1. turn off real time scan (anti virus)
...	...	@@ -16,43 +16,50 @@
16	16
17	17	1. run schema extracts
18	18	11. not in parallel!
	23	+11. [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
	24	+11. C:\Users\alliancetest\.mssqlscripter
	25	+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
19	19
20	20	1. create db
21	21
22	22	1. create schemas
23		-11. prep scripts first
	30	+11. prep scripts first remove non applicable scripting
24	24	11. document references
25	25	11. make sure ddl audit triggers are disabled
26	26
	34	+1. enable compresssion on applicable tables
	35	+11. tblAudit etc
	36	+
27	27	1. disable all indexes except clustered
28	28
29	29	1. run imports [parallel]
30	30	11. imports runs from smallest to largest table
	41	+
	42	+1. verify record counts from pre and post
	43	+
	44	+1. enable indexes
	45	+
	46	+1. deploy new ddl audit triggers
	47	+​​​​​​​
	48	+1. enable ddl trigger
	49	+
	50	+1. run db security scripts
	51	+11. creates db groups and ad groups
	52	+
	53	+1. update all settings to new environment
	54	+
	55	+1. do audit table test
	56	+
	57	+1. scale db down to minimum
	58	+
31	31
32	32
33	33	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
34	34	11. reason for this is to identify any procedure/triggers/functions that dont compile
35		-1. once this is done examine results and fix stored procedures on database so that they can compile, ie add missing columns or modify code to not require them
36		-11. repeat step 1 and 2 until you get zero objects that can't compile
37		-1. check sql code for any reserved varables ie... and fix on DB
38		-1. run dacpac export
39		-11. make sure nothing is running on source DB
40		-11. upgrade source DB to high level for quicker export and set back to what it was once done
41		-11. cmd
42		-1. run dacpac publish to managed instance
43		-1.
44	44
45	45	* (((
46		-(% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
47		-[[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
48		-
49		-* C:\Users\alliancetest\.mssqlscripter
50		-* 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
51		-
52	52
53	53	)))
54		-* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
55		-
56	56
57	57	{{code language="sql"}}
58	58	-- index