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.