Home : Database Upgrade 7.8.6
Q14593 - INFO: Database Upgrade 7.8.6
With the release of WIMS Client 7.8.6 a database upgrade is required.  The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 7.8.6 client. 

Tech Notes:

SQL Server Scripts:

OPSROOT

ALTER TABLE PORTALSCHEDULE ADD WHERECLAUSE NVARCHAR(2000)
ALTER TABLE PORTALSCHEDULE ALTER COLUMN Q2VLIST NVARCHAR (max) NULL
ALTER TABLE PORTALQUEUE ALTER COLUMN Q2VLIST NVARCHAR (max) NULL
ALTER TABLE CALCQUEUE ALTER COLUMN VLIST NVARCHAR (max) NULL
ALTER TABLE CALCNODEQUEUE ALTER COLUMN VLIST NVARCHAR (max) NULL

FACILITY DATABASES

ALTER TABLE CALCGRP ADD WHERECLAUSE NVARCHAR (2000) NULL

ALTER TABLE HDE ADD HEADER_HEIGHT [FLOAT] NULL
ALTER TABLE HDE ADD HEADERFONT_NAME NVARCHAR(50) NULL
ALTER TABLE HDE ADD HEADERFONT_SIZE [FLOAT] NULL
ALTER TABLE HDE ADD HEADERFONT_BOLD [numeric](18, 0) NULL
ALTER TABLE HDE ADD HEADERFONT_ITALIC [numeric](18, 0) NULL

ORACLE:

OPSROOT

ALTER TABLE PORTALSCHEDULE ADD WHERECLAUSE NVARCHAR2 (2000) NULL

FACILITY DATABASES

ALTER TABLE CALCGRP ADD WHERECLAUSE NVARCHAR2 (2000) NULL

ALTER TABLE HDE ADD HEADER_HEIGHT NUMBER NULL
ALTER TABLE HDE ADD HEADERFONT_NAME NVARCHAR2(50) NULL
ALTER TABLE HDE ADD HEADERFONT_SIZE NUMBER NULL
ALTER TABLE HDE ADD HEADERFONT_BOLD NUMBER NULL
ALTER TABLE HDE ADD HEADERFONT_ITALIC NUMBER NULL

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 6/24/2020 11:21 AM.
Last Modified on 10/5/2020 7:49 AM.
Last Modified by Scott Dorner.
Article has been viewed 1171 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article