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
-
... ... @@ -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