...
Technology Assessment (TODO)
Platform Type | WinFormConsole |
|---|---|
Database Platform and Version | Oracle 11c |
Development Language and Framework | C# |
Operating System and Version | Windows 10 |
Additional Dependencies | None |
Authentication | None |
Environment Access Information
...
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV |
|
| CAWISD | |
PREACC |
|
| PREACC_CA | |
ACC |
|
| CAWISA | |
PROD |
|
| CAWISP | |
TRAINING |
|
|
|
|
System Overview
<--->
Good To Know
<--->
How-To and Fixes
<--->This is an one-off project kept for historical purposes and as a reference in dealing with Oracle LONG RAW.
This project was created to transfer missing LONG RAW attachments from an old CAWIS database to a new one.
When the new WCAG-compliant CAWIS went in Production, one of the step was to create a copy of the database and rename the old one to CAWISV3 (V3 standing for the classic ASP version). Due to some issue, the attachments for SDR were partially deleted (the actual data was zero-byted). Since the document were still existing in the old copy of the database, a script was created to synchronize the data between the two databases.
Good To Know
The script reads both databases attachments in their respective M76_SDR_ATTACHMENTS table. It then compare the size of the attachments one by one and import the data from the old database if a discrepancy is detected.
Due to how the script reads the data, it must have enough memory to keep in memory at least two times the biggest attachment.