Home : WIMS Database Upgrade 7.7.0
Q14484 - INFO: WIMS Database Upgrade 7.7.0

With the release of WIMS Client 7.7.0 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.0 client. 

This database upgrade added columns to the EXPORTHDR table to support narrow format export (see Utilities>Export>Export to Excel ).

Tech Notes:

SQL Server Scripts:

ALTER TABLE EXPORTHDR ADD EXPORTFORMAT NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD01 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD02 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD03 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD04 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD05 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD06 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD07 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD08 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD09 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD10 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD11 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD12 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD13 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD14 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD15 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD16 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD17 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD18 NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE EXPORTHDR ADD NFFIELD19 NVARCHAR(50) NULL DEFAULT (NULL)

 Oracle Scripts

ALTER TABLE EXPORTHDR ADD EXPORTFORMAT NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD01 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD02 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD03 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD04 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD05 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD06 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD07 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD08 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD09 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD10 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD11 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD12 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD13 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD14 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD15 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD16 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD17 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD18 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE EXPORTHDR ADD NFFIELD19 NVARCHAR2(50) DEFAULT 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 1/24/2018 10:57 AM.
Last Modified on 1/24/2018 10:57 AM.
Last Modified by Scott Dorner.
Article has been viewed 699 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article