Wiki source code of EIB - Eswatini Insurance Brokers
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 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 | |||
| 18 | === Migration Observations: === | ||
| 19 | |||
| 20 | * Updating the license requires that we uncomment the security check in the following trigger: | ||
| 21 | ** Table: prgSystemSettings > Trigger: tr_prgSystemSettings | ||
| 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'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. |