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
-
... ... @@ -5,7 +5,7 @@ 5 5 * Domain: SZ.EIB.BZ 6 6 * VPN: [[https:~~/~~/www.sonicwall.com/products/remote-access/vpn-clients/>>url:https://www.sonicwall.com/products/remote-access/vpn-clients/]] 7 7 * VPN Password (Protected): EB Sphere (Pty) Ltd\EB Sphere (Pty) Ltd Team Site - Documents\Clients\Eswatini Insurance Brokers (former Aon Swaziland)\AON Swaziland (Eswatini Insurance Brokers)\Docs\EIB VPN Remote Access.docx 8 -* Everest.NET version 298 +* Everest.NET Version: 29 9 9 * Azure Blob Storage Explorer - NB! The latest version of this application does **NOT** run on the client's own environment. Please use the version specified here: [[Github - Azure Storage Explorer v1.28.1>>https://github.com/microsoft/AzureStorageExplorer/releases/tag/v1.28.1]] 10 10 11 11 === Managed Instance: === ... ... @@ -17,13 +17,15 @@ 17 17 18 18 === Migration Observations: === 19 19 20 -* Updating the license mayrequire that we uncomment the security check in the following trigger:20 +* Updating the license requires that we uncomment the security check in the following trigger: 21 21 ** Table: prgSystemSettings > Trigger: tr_prgSystemSettings 22 - 23 -((( 24 -(% class="wikigeneratedid" id="HAzureBlobStorageExplorer:" %) 25 -((( 26 26 * Staging documents database was restored from another client and required the truncation of the document table. 27 -* Staging database was restored from the live database at the client environment. 28 -))) 29 -))) 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]