Wiki source code of EIB - Eswatini Insurance Brokers
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
9.1 | 1 | === Client Environment: === |
| |
2.1 | 2 | |
| |
9.1 | 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 | ||
| |
12.1 | 8 | * Everest.NET Version: 29 |
| |
9.1 | 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]] |
| |
2.1 | 10 | |
| |
9.1 | 11 | === Managed Instance: === |
| |
2.1 | 12 | |
| |
9.1 | 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 | |||
| |
11.1 | 20 | * Updating the license requires that we uncomment the security check in the following trigger: |
| |
10.1 | 21 | ** Table: prgSystemSettings > Trigger: tr_prgSystemSettings |
| 22 | * Staging documents database was restored from another client and required the truncation of the document table. | ||
| |
14.1 | 23 | * Staging database was restored from the live database at the client's environment. |
| |
15.1 | 24 | * Passwords for the various users were generated using: [[https:~~/~~/www.useapassphrase.com/>>https://www.useapassphrase.com/]] (Replace the spaces with dots) |
| |
16.1 | 25 | * DB Scrub - The following database alterations were required once we restored the database to the managed instance: |
| |
17.1 | 26 | ** Local path references must be directed to the (D:\) drive. Values may include C:\, C:\Temp etc... |
| |
13.1 | 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. | ||
| |
18.1 | 31 | * Used the following stored procedure to assist with finding potential data changes: [dbo].[sp_scan_db] |