Changes for page EIB - Eswatini Insurance Brokers
Last modified by Kyle Hill on 2024/05/08 11:23
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -14,6 +14,7 @@ 14 14 * Databases: (EIB_Staging_Everest, EIB_Live_Everest, EIB_Staging_Everest_Documents, EIB_Live_Everest_Documents) 15 15 * Server address: 172.30.0.7 16 16 * File Storage Directory (Root): D:\EIB_Staging_Everest\ 17 +* Domain: africa.ebsphere.eib_staging_everest 17 17 18 18 === Migration Observations: === 19 19 ... ... @@ -21,10 +21,11 @@ 21 21 ** Table: prgSystemSettings > Trigger: tr_prgSystemSettings 22 22 * Staging documents database was restored from another client and required the truncation of the document table. 23 23 * Staging database was restored from the live database at the client's environment. 24 -* Passwords for the various users generated using this website: [[https:~~/~~/www.useapassphrase.com/>>https://www.useapassphrase.com/]] (Replace the spaces with dots)25 -* The following database updates were required once we restored the database to the managed instance:26 -** Local path references must be directed to the (D:) drive. Values may include C:\, C:\Temp etc... 25 +* Passwords for the various users were generated using: [[https:~~/~~/www.useapassphrase.com/>>https://www.useapassphrase.com/]] (Replace the spaces with dots) 26 +* DB Scrub - The following database alterations were required once we restored the database to the managed instance: 27 +** Local path references must be directed to the (D:\) drive. Values may include C:\, C:\Temp etc... 27 27 ** GRANT statements removed 28 28 ** Connection strings must point to the new environment 29 29 ** Reference to IP address to be resolved 30 30 * STP file was created for the client using an existing file. 32 +* Used the following stored procedure to assist with finding potential data changes: [dbo].[sp_scan_db]