Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

March 27, 2024

ORION Ticket Request REQ30722 has been submitted for you

View Details/Voir les détails

https://smartit.tc.gc.ca/smartit/app/#/workorder/IDGAA5V0FPSGIAS1AOYMS0AAMKVRT8

\uD83D\uDCD8 Instructions

  1. Navigate to Smart IT: Smart IT Universal Client 20.02 | Dashboard (tc.gc.ca)

  2. Select Create New > Work Order from the menu.

3. Enter your name in the Customer field. The Company and Remedy Login ID will autocomplete once a valid name is entered.

4. Select the Browse All Templates button:

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 

Database Refresh: Refresh LEIS DEV (both LEIS and LEIS Auth) DBs with copies of LEIS Production

and Description 

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 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 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.

  1. Conformation Email 

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
  • No labels