Database refresh from Production

Owned by francois.blais (Unlicensed), created
Last updated: May 16, 2024 by Tsizis, Mark (TC TC)
3 min read

 Instructions

  1. Capture any changes made to the dev database that could be overridden.

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

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

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

View Details/Voir les détails

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

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