Choosing your SQL Server Edition

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

 

  

SQL Server Editions

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

 

** Client access licenses (CALs) are required for every user or device accessing a server in the Server + CAL licensing model.

*** Not recommended to install SQL server on a domain controller.  This includes Essential Editions of Windows Server.

Contact Us to Learn More

 

Back to v12 Upgrade Path