Versions Compared

Old Version 1

changes.mady.by.user Checkmarx Bot

Saved on

compared with

New Version 2

changes.mady.by.user Jeff Duke

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Migration Path

Setup Foundation Elements for VetView

Note

If you are migrating data from a UVIS (Oracle) installation, you'll need to download the following scripts: Tables, Constraints, and Indices Script, the Sequences Script, and the Localization Script.

Tip

You can go into the database tool of your choice to run these scripts.

 

  • You'll now need to log into the database as the VetView user account you created in the previous step (when you ran the user script).
  • Now execute the VetView Tables, Constraints, and Indices script.  
  • Next, execute the VetView Sequences script.
    • Finally, execute the Localization script.

    For running script files we recommend using a Database developer tool like SQL Developer or TOAD. This allows you to preview and update any script prior to executing it, it also allows you to see progress and any error messages.

    Example Connection in SQL Developer                                          Example Connection in TOAD

    Image Added                             Image Added

     

    All script file should be executed using the VetView account.

    There are 4 scripts that need to be run to prior starting up the VetView project on the Web Server

    1. Tables, Constraints, and Indices
      1. The Tables 0.9.5.sql file includes a single line statement that defines each table. Some tables that include CLOB columns have tablespace definition that may need to be replaced depending on the name of the tablespaces defined when setting up the database.
      2. Code Block
        languagesql
        titleExample Table Create Statement
        CREATE TABLE NOTIFICATIONS ( NOTIFICATION_ID NUMBER(19) NOT NULL, VERSION NUMBER(19) NOT NULL, CREATED_DATE TIMESTAMP(6), LUD TIMESTAMP(6), LUN VARCHAR2(30 CHAR), MESSAGE_TEXT CLOB NOT NULL, MSG_FROM NUMBER(19), MESSAGE_LINK NUMBER(19), MESSAGE_LINK_TYPE VARCHAR2(30 CHAR), MSG_TO NUMBER(19) NOT NULL, MESSAGE_TO_SECTION_LINK NUMBER(19), MESSAGE_TO_SERVICE_LINK NUMBER(19), MESSAGE_TYPE VARCHAR2(30 CHAR) NOT NULL, STATUS VARCHAR2(30 CHAR) NOT NULL ) LOB (MESSAGE_TEXT) STORE AS ( TABLESPACE DATA_SMALL ENABLE STORAGE IN ROW CHUNK 8192 RETENTION);

CREATE INDEX NOTIFICATIONS_MSG_FROM_INDEX ON NOTIFICATIONS (MSG_FROM);

CREATE INDEX NOTIFICATIONS_MSG_TO_INDEX ON NOTIFICATIONS (MSG_TO);

ALTER TABLE NOTIFICATIONS ADD (  PRIMARY KEY (NOTIFICATION_ID) ENABLE VALIDATE);

ALTER TABLE NOTIFICATIONS ADD (  CONSTRAINT FK4BD694E880B55DEB FOREIGN KEY (MSG_FROM) REFERENCES EMPLOYEE (EMP_ID) ENABLE VALIDATE,  CONSTRAINT FK4BD694E88DBFBC3C FOREIGN KEY (MSG_TO) REFERENCES EMPLOYEE (EMP_ID) ENABLE VALIDATE);
    1. Sequences
    2. Localization 
    3. Security Roles and Admin User Account

     

     


    Next Step

    Populate Data ( Test or Migration )

     

    ...