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
-
... ... @@ -28,7 +28,10 @@ 28 28 Update Synonyms for Documents and Audit if relevant 29 29 30 30 Remove old data using the script "\Dropbox\EBSphere\Everest SQL\Special Scripts\_Debug Scripts [DO NOT RUN]\Script for new Database [DO NOT RUN]\Clear Data [DO NOT RUN].sql" 31 - - Ensure that you DO NOT run this on the wrong database 32 -\\Run dba.dbo.sp_scan_db '%HLL[_]%','HLM_Staging_Everest' 31 + - Ensure that you DO NOT run this on the wrong database 33 33 33 +Truncate the documents db 34 + 35 +Run dba.dbo.sp_scan_db '%CLIENT[_]%','CLIENT_ENV_Everest' to identify any scripts or tables with old references and update them to reference the new database and client 36 + 34 34