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
-
... ... @@ -27,11 +27,7 @@ 27 27 28 28 Update Synonyms for Documents and Audit if relevant 29 29 30 -Remove old data using the script " \Dropbox\EBSphere\Everest SQL\Special Scripts\_DebugScripts[DO NOTRUN]\Script for new Database[DONOTRUN]\Clear Data [DONOTRUN].sql"30 +Remove old data using the script "Truncate All Tables - NEW CLIENTS ONLY.sql" 31 31 - Ensure that you DO NOT run this on the wrong database 32 32 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 - 37 37