CAWIS_DBRESX
- Alexandre Bédard
- Samy Touabi (Unlicensed)
System Profile
System Full Name | Continuing Airworthiness Web Information System - Database Resource Editor |
Business Administrator |
|
Business Owner |
|
Director |
|
Subject Matter Expert | Alexandre Bédard |
Division |
|
NTARS Code |
|
Source Location |
|
Source Code Location | |
Migration to DevOps | |
New Source Code Location (DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAWIS_DBRESX |
Technology Assessment
Platform Type | WinForm |
|---|---|
Database Platform and Version | Oracle 18c |
Development Language and Framework | C# |
Operating System and Version | Windows 10 |
Additional Dependencies | None |
Authentication | Custom |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV |
|
|
| CAWISD |
PREACC |
|
|
| PREACC_CA |
ACC |
|
|
| CAWISA |
PROD |
|
|
| CAWISP |
TRAINING |
|
|
|
|
Note: Although these are the databases that this program is designed to work with, it can support any database that include the proper tables.
System Overview
This program is used to edit resources in database tables that mimic the functionality of the RESX files. Its main utility is to synchronize the resources between databases by providing the connection string of both. It does so by comparing the update date of each resource and updating the old or missing resources.
Good To Know
While syncing the resources, it will try to disable the triggers on the resource tables to avoid the automatic updating of the update date, since this would lead to a constant updating if the program is run more than once.
How-To and Fixes
<--->