To manually create the InventoryControl Enterprise database, download the scripts from https://dl.waspbarcode.com/wasp/SupportFiles/InstallNewDbIC60.zip

The scripts must be run on the SQL Server in this order:

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

To install the Sample Database, run these additional scripts:

File1=CreateDatabase_Trial.sql
File2=SetDbOptions_Trial.sql
File3=CreateInventoryDataTypes_Trial.sql
File4=UpgradeInventoryTables_Trial.sql  **
File5=CreateTableConstraints_Trial.sql
File6=CreateInventoryViews_Trial.sql
File7=CreateInventoryStoreProc_Trial.sql
File8=CreateInventoryTriggers_Trial.sql
File9=Install_ENGLISH_Inserts_Trial.sql
File10=CreateWaspAccounts_Trial.sql
File11=InventoryTrialData.sql

** If you get errors during this script saying Invalid column name 'inventoried' or 'inventoried_2', these 2 errors are ok.

These scripts are for the initial release version 6.0.