The ShipRush Database Manager

** For advanced users only **

** Make a backup of the ShipRush database before using this tool **

Because this is an advanced tool that is not needed during normal operation, there is no icon to start the DB Manager. Rather, it needs to be found in the program directory to start it:

   C:\Program Files\Z-Firm LLC\ShipRush v6\ShipRushDBManager.exe

In normal system operation, the ShipRush Database Manager (aka DBManager) is only needed to make and restore backups of the database. However there are a number of useful features of this tool.

DB Maintenance: This area allows the database to be verified and reindexed. It also allows one-button backup and restore of the ShipRush database. To restore, ShipRush should be closed on all PC's and the Z-Firm ShipRush service should be stopped.

The Purge feature to trim the database is also here. First select the desired database (ShipRush or Order Manager) and then use the Purge feature.

Move Database can be used to relocate the ShipRush database from a local drive to a network server. It will also update the local ShipRush configuration to point to the new location. Note that other workstations will need to be adjusted to point to the new database location.

Run Query is only for use by Z-Firm Technical Support.

Command Line Tools

ShipRush DB Manager can be executed from the command line to perform certain maintenance functions.

Note that in most cases, all copies of ShipRush, and the ShipRush Service, should be shut down prior to running these commands.

Execute "shiprushdbmanager.exe -?" to see the syntax.

Available commands:

-?, /?, -HELP, /HELP for help
-REPAIR or /REPAIR for Check/Repair/Reindex database
-BACKUP or /BACKUP for Database backup
-PURGE <date> [-SURE] for Purge old data from the database

where:
  <date> in format specified in OS settings
  "-SURE" suppresses confirmation dialog before purge starts