Last modified by Rudi Marais on 2024/03/28 18:51

<
From version < 8.19 >
edited by Rudi Marais
on 2024/03/28 18:34
To version < 8.22 >
edited by Rudi Marais
on 2024/03/28 18:37
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -30,6 +30,9 @@
30 30  11. document references
31 31  11. make sure ddl audit triggers are disabled
32 32  
33 +1. enable compresssion on applicable tables
34 +11. tblAudit etc
35 +
33 33  1. disable all indexes except clustered
34 34  
35 35  1. run imports [parallel]
... ... @@ -38,11 +38,14 @@
38 38  1. verify record counts from pre and post
39 39  
40 40  1. enable indexes
41 -​​​​​​​
44 +
42 42  1. deploy new ddl audit triggers
43 43  ​​​​​​​
44 44  1. enable ddl trigger
45 45  
49 +1. run db security scripts
50 +11. creates db groups and ad groups
51 +
46 46  1. update all settings to new environment
47 47  
48 48  1.
... ... @@ -65,9 +65,6 @@
65 65  (% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
66 66  [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
67 67  
68 -* C:\Users\alliancetest\.mssqlscripter
69 -* 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
70 -
71 71  
72 72  )))
73 73  

Need help?

If you need help with XWiki you can contact: