Summary

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

Details

Page properties

Content

...	...	@@ -6,6 +6,9 @@
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
10	10
11	11	1. turn off real time scan (anti virus)
...	...	@@ -28,6 +28,14 @@
28	28
29	29	1. run imports [parallel]
30	30	11. imports runs from smallest to largest table
	34	+​​​​​​​
	35	+1. verify record counts from pre and post
	36	+
	37	+1. enable indexes
	38	+1. enable ddl trigger
	39	+
	40	+1.
	41	+
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