Home : Database Upgrade 842
Q14833 - INFO: Database Upgrade 842

With the release of WIMS Client 8.4.2 a database upgrade is required.  The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.2.6 client. 


Tech Notes:

SQL Server Scripts:

Facility Databases

ALTER TABLE MDE ADD UD1FIELD [Numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE MDE ADD UD2 [Numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE MDE ADD UD2FIELD [Numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE MDE ADD TYPESOURCE [Numeric](18, 0) NULL DEFAULT (NULL)

ALTER TABLE VARDESC ALTER COLUMN DESCRIPTION NVARCHAR(1000)

Oracle:

Facility Databases

ALTER TABLE MDE ADD UD1FIELD NUMBER NULL
ALTER TABLE MDE ADD UD2 NUMBER NULL
ALTER TABLE MDE ADD UD2FIELD NUMBER NULL
ALTER TABLE MDE ADD TYPESOURCE NUMBER NULL

ALTER TABLE VARDESC MODIFY(DESCRIPTION NVARCHAR2(1000))

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 10/3/2025 4:51 PM.
Last Modified on 10/7/2025 9:18 AM.
Last Modified by Scott Dorner.
Article has been viewed 39 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article