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
-
... ... @@ -26,7 +26,7 @@ 26 26 1. create db 27 27 28 28 1. create schemas 29 -11. prep scripts first remove non applicable scripting29 +11. prep scripts first 30 30 11. document references 31 31 11. make sure ddl audit triggers are disabled 32 32 ... ... @@ -34,20 +34,12 @@ 34 34 35 35 1. run imports [parallel] 36 36 11. imports runs from smallest to largest table 37 - 37 + 38 38 1. verify record counts from pre and post 39 39 40 40 1. enable indexes 41 - 42 -1. deploy new ddl audit triggers 43 - 44 44 1. enable ddl trigger 45 45 46 -1. run db security scripts 47 -11. creates db groups and ad groups 48 - 49 -1. update all settings to new environment 50 - 51 51 1. 52 52 53 53 ... ... @@ -68,7 +68,10 @@ 68 68 (% class="wikigeneratedid" id="Hhttps:2F2Fgithub.com2Fmicrosoft2Fmssql-scripter" %) 69 69 [[https:~~/~~/github.com/microsoft/mssql-scripter>>https://github.com/microsoft/mssql-scripter]] 70 70 71 - 63 +* C:\Users\alliancetest\.mssqlscripter 64 +* 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 65 + 66 + 72 72 ))) 73 73 74 74 {{code language="sql"}}