Last modified by Rudi Marais on 2024/03/28 18:51
<
From version < 8.16 >
edited by Rudi Marais
on 2024/03/28 18:32
To version < 8.24 >
edited by Rudi Marais
on 2024/03/28 18:48
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -7,6 +7,7 @@
7 7  
8 8  
9 9  1. put db in readonly mode
10 +11. stop all applicable services
10 10  11. ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
11 11  
12 12  1. scale db to accetable performance ie dtus 500
... ... @@ -19,24 +19,38 @@
19 19  
20 20  1. run schema extracts
21 21  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
22 22  
23 23  1. create db
24 24  
25 25  1. create schemas
26 -11. prep scripts first
30 +11. prep scripts first remove non applicable scripting
27 27  11. document references
28 28  11. make sure ddl audit triggers are disabled
29 29  
34 +1. enable compresssion on applicable tables
35 +11. tblAudit etc
36 +
30 30  1. disable all indexes except clustered
31 31  
32 32  1. run imports [parallel]
33 33  11. imports runs from smallest to largest table
34 -​​​​​​​
41 +
35 35  1. verify record counts from pre and post
36 36  
37 37  1. enable indexes
45 +
46 +1. deploy new ddl audit triggers
47 +​​​​​​​
38 38  1. enable ddl trigger
39 39  
50 +1. run db security scripts
51 +11. creates db groups and ad groups
52 +
53 +1. update all settings to new environment
54 +
40 40  1.
41 41  
42 42  
... ... @@ -57,13 +57,8 @@
57 57  (% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
58 58  [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
59 59  
60 -* C:\Users\alliancetest\.mssqlscripter
61 -* 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
62 -
63 63  
64 64  )))
65 -* ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT
66 -
67 67  
68 68  {{code language="sql"}}
69 69  -- index

Applications

Navigation

Need help?

If you need help with XWiki you can contact: