| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
\uD83D\uDCD8 Instructions
Capture any changes made to the dev database that could be overridden.
Developer will need to create prod external and internal accounts before the refresh to validate and debug proper account migration of the test accounts from prod to dev. Capture test accounts details in dev DB before migration.
Navigate to Smart IT: Smart IT Universal Client 20.02 | Dashboard (tc.gc.ca)
Select Create New > Work Order from the menu.
...
5. From the available templates, select the Database Backup option. This helps speeds things up by populating database related fields in the form.
...
6. Enter a Summary
| Code Block |
|---|
Database Refresh: Refresh LEIS DEV (both LEIS and LEIS Auth) DBs with copies of LEIS Production |
and Description
| Code Block |
|---|
1. Please refresh LEIS DEV (both LEIS and LEIS Auth) DBs with copies of LEIS Production databases.
2. Please re-create synonyms or make sure LIESD (or LEISA) points to the correct TCDIR schema to have correct view LEIS.DIRECTORY_CLIENT |
based on the environment to be refreshed. In this case, it is the development environment. Specify the schemas (LEIS and LEIS_Auth). Mention to recreate the synonyms / make sure LeisD or LeisA point to the correct TCDIR schema to have correct view: LEIS.DIRECTORY_CLIENT_VW .
7. Add Scheduled Dates if they are known and click Save Ticket to open the ticket.
...
March 27, 2024
ORION Ticket Request REQ30722 has been submitted for you
https://smartit.tc.gc.ca/smartit/app/#/workorder/IDGAA5V0FPSGIAS1AOYMS0AAMKVRT8
| Code Block |
|---|
From: Alobo, Evalsam David (TC/TC) <evalsamdavid.alobo@tc.gc.ca>
Sent: Thursday, March 28, 2024 4:23 PM
To: Tsizis, Mark (TC/TC) <mark.tsizis@tc.gc.ca>
Cc: Cordick, Paul (TC/TC) <paul.cordick@tc.gc.ca>; Panina, Ekaterina (TC/TC) <ekaterina.panina@tc.gc.ca>
Subject: WO202610 : DataBase Backup Request
UNCLASSIFIED / NON CLASSIFIÉ
Good afternoon,
Want to inform you that this request has been completed.
Please confirm.
We noticed references to materialised views in LEIS however, there are no MV in DEV, Acc or Prod.
Thank you.
Alobo, Evalsam David
IT Analyst Database Management, Enterprise Solutions
Transport Canada / Government of Canada
evalsamdavid.alobo@tc.gc.ca / Tel: 1-639-384-9815
Analyste informatique Gestion de bases de données Solutions d’entreprise
Transports Canada / Gouvernement du Canada
evalsamdavid.alobo@tc.gc.ca / Tél 1-639-384-9815
|