Changes for page Add New Client to managed instance
Last modified by Phillip Swanepoel on 2024/10/10 12:42
Change comment:
(Autosaved)
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -18,6 +18,16 @@ 18 18 Create database using current naming scheme in azure (currently by copying a current working database, with the data removed in a later step). 19 19 - User Groups are added automatically through a job within 5 minutes. 20 20 21 -Setup SVC users and delete base database users using "SKL_sqlmi_accesss_SKL.sql" 21 +Setup SVC users and delete base database users using "SKL_sqlmi_accesss_SKL.sql" 22 + - Enable SQLCMD mode under Query > SQLCMD Mode 23 + - Client Code: Three Letter Acronym 24 + - TargetEnv: Live | Staging 25 + - ClearLogins: 2 26 + - Passwords in script to be updated to the ones used above 22 22 28 +Update Synonyms for Documents and Audit if relevant 29 + 30 +Remove old data using the script "Truncate All Tables - NEW CLIENTS ONLY.sql" 31 + - Ensure that you DO NOT run this on the wrong database 32 + 23 23