Changes for page migrate to managed instance
Last modified by Rudi Marais on 2024/03/28 18:51
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -7,7 +7,6 @@ 7 7 8 8 9 9 1. put db in readonly mode 10 -11. stop all applicable services 11 11 11. ALTER DATABASE Everest_Test SET READ_ONLY WITH NO_WAIT 12 12 13 13 1. scale db to accetable performance ie dtus 500 ... ... @@ -31,9 +31,6 @@ 31 31 11. document references 32 32 11. make sure ddl audit triggers are disabled 33 33 34 -1. enable compresssion on applicable tables 35 -11. tblAudit etc 36 - 37 37 1. disable all indexes except clustered 38 38 39 39 1. run imports [parallel] ... ... @@ -51,10 +51,8 @@ 51 51 11. creates db groups and ad groups 52 52 53 53 1. update all settings to new environment 54 - 55 -1. do audit table test 56 56 57 -1. scale db down to minimum51 +1. 58 58 59 59 60 60 ... ... @@ -74,7 +74,7 @@ 74 74 (% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %) 75 75 [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]] 76 76 77 - 71 + 78 78 ))) 79 79 80 80 {{code language="sql"}}