SmarterTrack 9.x Help
This documentation is for a product that is no longer supported by SmarterTools.

Setting Up the Database

SmarterTrack needs a database to store data. SmarterTools customers using an installed version of the software can run SmarterTrack with any of the database servers listed below. Note: SmarterTrack will only prompt you to automatically create a database if it does not already exist and you are connecting to a Microsoft SQL Server. In order to set up SmarterTrack with MySQL, the database will need created manually before starting the Setup Wizard.

Microsoft SQL Server (Express, Web, Standard, or Enterprise)

Microsoft SQL Server is the recommended database to use for SmarterTrack. Express Edition is available at no cost and will support the vast majority of SmarterTrack customers. For those needing advanced services or large amounts of database storage, Web, Standard or Enterprise Editions are recommended.

Microsoft SQL Server 2005 and later are supported, but for best performance, it is recommended to use Microsoft SQL Server 2008 R2 or later. If possible, use of 64-bit is also recommended.

For more information or to download SQL Server, please see:

For best results, when downloading and installing SQL Server, choose the Database With Tools download and install Management Studio Express with the database.

MySQL

MySQL can be used as a back-end database for SmarterTrack. MySQL Community Server can be freely downloaded and used for most customers. For those needing advanced service and support, MySQL offers a paid Enterprise Edition.

MySQL versions 5.1 and later are supported, but it is recommended to use 5.5 or later if possible. In addition, use of 64-bit is recommended. Note: At this time, MySQL 5.5.14 is the only version not compatible with SmarterTrack.

For more information or to download MySQL Community Server, please see:

SmarterTrack will only support the InnoDB database engine and will attempt to use InnoDB for all upgrades and new installations. For information on converting a database to InnoDB, see the KB article How To Convert from MyISAM to InnoDB

Additional Information

Please refer to the KB articles How To Set Up the SmarterTrack Database on a Dedicated Server or How To - Set Up the Database for Shared Hosting for step-by-step instructions and more information regarding the database backend.