Most small to medium size businesses can use the free edition of SQL Server called SQL Express. SQL Express does have some limitations. SQL Express is limited to using 4 CPU cores and does have memory allocation limits. It is also limited to a maximum database size of 10GB. Please note that once your database reaches the 10GB size SQL Express shuts down. If your current database size is close to 10GB or if your store has a high transaction volume it is highly recommended you purchase one of the SQL Standard editions.
If you are above the 10GB limit you will need to purchase one of the SQL Standard editions. SQL Standard can be purchased directly from Microsoft or from many other technology companies. Tri-Tech is not a reseller of SQL Server.
If you plan to use active-e services or active-e Mobile Applications you can use SQL Express or SQL Standard (licensed by CPU core). You should not purchase SQL Standard (licensed by server + users).
In AIMsi you can go to Help>About AIMsi-Pro v11.0 to see your current database size. During test conversions we have seen databases convert to approximately the same size and other increase in size up to 25%. You should allow a growth factor of up to 25% when determining if you can use SQL Express or not.
During the AIM v12 installation process you can optionally download and install the SQL Server Express edition. If you are using the SQL Server Standard edition you will obtain the installation from whoever you purchased it from.
Where to find your Database Size
* Find database size with AIMsi > Help > About AIMsi-Pro v11.0
Minimum SQL Server Version 2017
DETAILS | ||
---|---|---|
SQL Server Editions | Ideal for … | Est Pricing (US$) |
Express | Free entry-level database that's ideal for small server data-driven applications of up to 10GB*. Can be used with Active-e. | Free |
Standard (licensed by CPU core) | Fully featured database for mid-tier applications. Ideal for medium and large stores with databases over 10GB. Can be used with Active-e. | Server ($950) + $6,000 for 4 CPU cores $3000/additional 2 core packs |
Standard (licensed by server + users) *Not Recommended* | Fully featured database for mid-tier applications. Ideal for medium and large stores with databases over 10GB. Cannot be used with Active-e. | Server ($950) + CAL** ($190ea) |
* Recommend moving to Standard edition for databases larger than 10GB
*** Not recommended to install SQL server on a domain controller. This includes Essential Editions of Windows Server.
Contact Us to Learn More