Changes for page Add New Client to managed instance
Last modified by Phillip Swanepoel on 2024/10/10 12:42
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -27,7 +27,11 @@ 27 27 28 28 Update Synonyms for Documents and Audit if relevant 29 29 30 -Remove old data using the script " TruncateAllTables-NEWCLIENTSONLY.sql"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 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 + 33 33