Summary

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

Details

Page properties

Content

...	...	@@ -6,18 +6,39 @@
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	+
14	14	1. create db
15		-1. create schema
	24	+
	25	+1. create schemas
16	16	11. prep scripts first
17	17	11. document references
18	18	11. make sure ddl audit triggers are disabled
	29	+
	30	+1. disable all indexes except clustered
	31	+
19	19	1. run imports [parallel]
20	20	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	+
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