Various Videos – Resetting Database

Resetting database

Here is a link to a video of the process

1) Stop the local Swiftcount service on the local server

2) Clearup the Swiftcount databases by running the script called Drop Swiftcount tables in the Swiftcount asset folder

3) Run the configuration and reconnect the databases to recreate Swiftcount tables After recreating the tables delete the keys for the Swiftcount_LiveProductCount and Swiftcount_Product_Count tables

4) Login to Swiftcount cloud and clear the database

5) On the local database Run Invmast_Uom_Add stored Procedure to reinsert all products in the table called Invmast_UOM

6) Start the Swiftcount service on the local computer to send the data back to Swiftcount (Products only) Monitor progress in log file located in C:/ProgramFiles(86)/Bas Technologies / Swiftcount for Windows

7) When products process is completed – Stop the service
On the local database Run LocationTableAdd stored Procedure to insert on hand quantities for non serialized or lotted items (AAA for all warehosues)
On the local database Run SerialNumberAdd stored Procedure to insert on hand quantities for serialized items
On the local database RunLotNumberAdd stored Procedure to insert on hand quantities for Lotted items

On the local server run the following statement to remove old 0 items:
delete from LocationTable where SerialNumber > ‘ ‘ and QUANTIT = 0

8) Start the Swiftcount service on the local computer to send the data back to Swiftcount (On hand quantities) Monitor progress in log file located in C:/ProgramFiles(86)/Bas Technologies / Swiftcount for Windows