Last modified by Kyle Hill on 2024/05/08 11:23
<
From version < 1.2 >
edited by Phillip Swanepoel
on 2024/04/30 08:50
To version < 20.1
edited by Kyle Hill
on 2024/05/08 11:23
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.phillips
1 +XWiki.kyleh
Content
... ... @@ -1,0 +1,32 @@
1 +=== Client Environment: ===
2 +
3 +* Server: 41.204.7.26:4433
4 +* Usernames: (aon1, aon2, aon3, aon4, aon5)
5 +* Domain: SZ.EIB.BZ
6 +* VPN: [[https:~~/~~/www.sonicwall.com/products/remote-access/vpn-clients/>>url:https://www.sonicwall.com/products/remote-access/vpn-clients/]]
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: 29
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 +
11 +=== Managed Instance: ===
12 +
13 +* Database Server: sqlmi-ebs-prod.public.2a5fe6cde9a7.database.windows.net,3342
14 +* Databases: (EIB_Staging_Everest, EIB_Live_Everest, EIB_Staging_Everest_Documents, EIB_Live_Everest_Documents)
15 +* Server address: 172.30.0.7
16 +* File Storage Directory (Root): D:\EIB_Staging_Everest\
17 +* Domain: africa.ebsphere.eib_staging_everest
18 +
19 +=== Migration Observations: ===
20 +
21 +* Updating the license requires that we uncomment the security check in the following trigger:
22 +** Table: prgSystemSettings > Trigger: tr_prgSystemSettings
23 +* Staging documents database was restored from another client and required the truncation of the document table.
24 +* Staging database was restored from the live database at the client's environment.
25 +* Passwords for the various users were generated using: [[https:~~/~~/www.useapassphrase.com/>>https://www.useapassphrase.com/]] (Replace the spaces with dots). The password which we generated for this client can be found on Azure.
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...
28 +** GRANT statements removed
29 +** Connection strings must point to the new environment
30 +** Reference to IP address to be resolved
31 +* 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]
image-20240508101931-1.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.kyleh
Size
... ... @@ -1,0 +1,1 @@
1 +13.8 KB
Content

Applications

Navigation

Need help?

If you need help with XWiki you can contact: