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] ... ... @@ -72,7 +72,7 @@ 72 72 (% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %) 73 73 [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]] 74 74 75 - 71 + 76 76 ))) 77 77 78 78 {{code language="sql"}}