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
-
... ... @@ -20,5 +20,12 @@ 20 20 * Updating the license requires that we uncomment the security check in the following trigger: 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 -* Staging database was restored from the live database at the client environment. 24 -* Passwords for the various users generated using this website: [[https:~~/~~/www.useapassphrase.com/>>https://www.useapassphrase.com/]] (Replace the spaces with dots) 23 +* Staging database was restored from the live database at the client's environment. 24 +* Passwords for the various users were generated using: [[https:~~/~~/www.useapassphrase.com/>>https://www.useapassphrase.com/]] (Replace the spaces with dots) 25 +* DB Scrub - The following database alterations 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... 27 +** GRANT statements removed 28 +** Connection strings must point to the new environment 29 +** Reference to IP address to be resolved 30 +* STP file was created for the client using an existing file. 31 +* Used the following stored procedure to assist with finding potential data changes: [dbo].[sp_scan_db]