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


Tech Notes:

SQL Server Scripts:

Facility Databases

ALTER TABLE VARDESC ALTER COLUMN UD1 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD2 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD3 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD4 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD5 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD6 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD7 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD8 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD9 NVARCHAR(255)

Oracle:

Facility Databases

ALTER TABLE VARDESC MODIFY(UD1 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD2 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD3 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD4 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD5 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD6 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD7 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD8 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD9 NVARCHAR2(255))

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 12/19/2025 2:02 PM.
Last Modified on 12/19/2025 2:02 PM.
Last Modified by Scott Dorner.
Article has been viewed 48 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article