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

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

Summary

Details

Page properties
Content
... ... @@ -30,9 +30,6 @@
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 -
36 36  1. disable all indexes except clustered
37 37  
38 38  1. run imports [parallel]
... ... @@ -41,14 +41,11 @@
41 41  1. verify record counts from pre and post
42 42  
43 43  1. enable indexes
44 -
41 +​​​​​​​
45 45  1. deploy new ddl audit triggers
46 46  ​​​​​​​
47 47  1. enable ddl trigger
48 48  
49 -1. run db security scripts
50 -11. creates db groups and ad groups
51 -
52 52  1. update all settings to new environment
53 53  
54 54  1.
... ... @@ -71,6 +71,9 @@
71 71  (% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %)
72 72  [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]]
73 73  
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 +
74 74  
75 75  )))
76 76  

Need help?

If you need help with XWiki you can contact: