TOPS Enterprise SQL Version


TOPS Enterprise SQL Version

TOPS New SQL Version Provides Enterprise wide secured data solution

In the standard version of TOPS Pro, all data and analyses are saved in a c-tree database and the program accesses the data files saved in “DATA” folder. If the “DATA” folder resides on a network drive, each user needs to have “WRITE” permission to all data files. In addition, each instance of TOPS requires a separate connection to the network server to handle its own data exchange with the database. It will slow the TOPS performance if multiple users are accessing the program at the same time.


TOPS Enterprise version uses Microsoft SQL Server database to manage data. Users have no direct access to files on the server, as MS SQL Database Server handles all the data exchange between TOPS clients and database.  This ensures the database will be secured and optimized, easy to maintain, have better performance, and be able to support other popular databases like Oracle or IMB DB2 with minor changes.


With TOPS Enterprise Version, you will also receive these additional TOPS functions:


Secured Single Sign-on
Users can log into TOPS Pro using their Windows login name, eliminating a separate login when accessing TOPS Pro. This is a global setting that can be enabled via TOPS Configuration settings, accessed by system supervisor only.


Secured User Roles
TOPS Program supervisor can assign users with different roles for various access rights to TOPS, including:

  • Viewer: Access only to TOPS Viewer program to open and view existing analyses but not making modifications.
  • Standard User: Rights to create analyses but with no authority to change configuration settings, import/export, or define products.
  • Power User: Rights to access all functions except for global configurations.
  • Supervisor: Full access to all functions of TOPS.


License Manager
TOPS Enterprise version comes with a License Manager which enables users to detach one license from the work group and place it temporarily onto a separate machine. If the detached license is not returned to the network within 30 days, it will expire automatically and the number of seats on the network will revert back to its original count.


Enhanced Analysis Management
For better work collaboration, users can use the Check In/Check Out function to control work flow of analyses. A revision history is also available for each analysis to provide a timeline of changes made.


Shipcase Search
This new function allows users to search through existing analyses for any shipcase bearing similar dimensions to the one being used in the current analysis. Users can specify the amount of deviation from the current shipcase for TOPS to search through the database or archived analyses.