Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Software
  • InventoryControl - How to run version 6 enterprise database upgrade scripts
Subscribe Download PDF

InventoryControl - How to run version 6 enterprise database upgrade scripts

Max Holden
2023-01-20
in Software

To manually upgrade an InventoryControl Enterprise database from any version 3.4 or newer to v6, download this file:

https://dl.waspbarcode.com/wasp/SupportFiles/UpgradeDbIC63.zip
 

Extract the file, then run the scripts in this order:
 

File1=Upgrade34to37.sql
File2=SetDbOptions.sql
File3=DropTableConstraints.sql
File4=UpgradeInventoryTables.sql *
File5=CreateTableConstraints.sql
File6=CreateInventoryViews.sql
File7=CreateInventoryStoreProc.sql
File8=CreateInventoryTriggers.sql
File9=Install_ENGLISH_Inserts.sql
File10=CreateWaspAccounts.sql
 

* While running this script, you may receive 2 messages:
 

Msg 207, Level 16, State 1, Line 6
 

Invalid column name 'inventoried'.
 

Msg 207, Level 16, State 1, Line 6
 

Invalid column name 'inventoried_2'.
 

These messages are due to the script being made to upgrade several different versions of the database to current, and those columns only exist in the earlier versions. As long as these are the only error messages received, the script has completed successfully and you can move on to the next one.
 

The scripts are current for the final patch for version 6, version 6.3.1.
 

Rate the quality of this page

This page was helpful :) :( This page was not helpful

16 of 39 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro