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

Tech Notes:

SQL Server Scripts:

OPSROOT

N/A - No scripts run.  Version simply updated to 774.

FACILITY DATABASES

ALTER TABLE [SETTINGS] ALTER COLUMN [CURVALUE] NVARCHAR(250)

Find the constraint to drop:

SELECT obj_table.NAME AS TableName, obj_Constraint.NAME AS ConstraintName, columns.NAME AS ColumnName
FROM sys.objects obj_table JOIN sys.objects obj_Constraint ON obj_table.object_id = obj_Constraint.parent_object_id
JOIN sys.sysconstraints constraints ON constraints.constid = obj_Constraint.object_id
JOIN sys.columns columns ON columns.object_id = obj_table.object_id AND columns.column_id = constraints.colid
WHERE obj_table.NAME = 'LC_TEST' AND columns.NAME='RL'

 ALTER TABLE LC_TEST DROP CONSTRAINT ConstraintNameReturnedFromQuery            'DF__LC_TEST__RL__45DE573A
 SP_RENAME 'LC_TEST.RL','RLBAD','COLUMN'")
 ALTER TABLE LC_TEST ADD RL FLOAT NULL DEFAULT (NULL)")
 UPDATE LC_TEST SET RL=RLBAD")
 ALTER TABLE LC_TEST DROP COLUMN RLBAD")
          

 

ORACLE:

OPSROOT

N/A - No scripts run.  Version simply updated to 774.

FACILITY DATABASES

N/A - No scripts run.  Version simply updated to 774.

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/24/2018 2:53 PM.
Last Modified on 10/24/2018 2:53 PM.
Last Modified by Scott Dorner.
Article has been viewed 2365 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article