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

Tech Notes:

SQL Server Scripts:

ALTER TABLE LC_BATCHTEMPLATEQC ALTER COLUMN RECORDER NUMERIC NOT NULL

ALTER TABLE LC_SAMPLETEST ADD CALCULATORTYPE [nvarchar](50) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETEST ADD CALCINPUT1  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD CALCINPUT2  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD CALCINPUT3  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD CALCINPUT4  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD CALCINPUT5  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD CALCINPUT6  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD INPUTRL  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD INPUTMDL  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD MDL  FLOAT NULL
ALTER TABLE LC_SAMPLETEST ADD RL  FLOAT NULL

ALTER TABLE LC_BATCH ADD CALCULATORTYPE [nvarchar](50) NULL DEFAULT (NULL)

ALTER TABLE LC_SAMPLETEST ALTER COLUMN BATCHQCFORMULA NVARCHAR(100)

 

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 3/29/2023 5:21 PM.
Last Modified on 3/29/2023 5:21 PM.
Last Modified by Scott Dorner.
Article has been viewed 1111 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article