Page Comparison

Scripts should be run in the specified order. Also, in the header of each script, there may be variables that need to be set with local values.  Also in each file there is a placeholder DBLink of @LABS.VET.UGA.EDU that will need to be either removed if migrating within the same database or replaced with the appropriate DBLink.

All employees come over associated with the role they were in UVIS.  However, every role imported into VetView is given ALL privileges by default.  You'll need to go through and edit each role's privileges.

With VetView we are making the assumption that Accessions Number have a basic structure of PREFIX - NUMBER - SUFFIX, so we are now storing in the accession table both a formatted accession number, but also the components of an accession number. The following script will help identify the accession numbers that are formatted incorrectly.

         SELECT * FROM uvis_dl_accessions a WHERE  A.ACCESSION_NO not like '%-%' OR A.ACCESSION_NO like ' %';