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

ORACLE:

OPSROOT

ALTER TABLE PORTALSCHEDULE ADD WHERECLAUSE NVARCHAR2 (2000) NULL

FACILITY DATABASES

ALTER TABLE CALCGRP ADD WHERECLAUSE NVARCHAR2 (2000) 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 6/24/2020 11:22 AM.
Last Modified by Steve Fifer.
Article has been viewed 174 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article