09-11-2019 12:45 AM
I have a query, we are using ACT premium 19.2 version for 30 users and using SQL Express version which is gone high till 9 GB approx. in size. So we are trying to purchase SQLSvrStd 2017 SNGL OLP NL. So, we need to confirm will this version fine for our 30 users and handle huge database?
Anyone who knows abt this would be a real help.
09-11-2019 03:18 AM
Take a look at the system requirements in the act! knowledge base for your act version, please. https://help.act.com/hc/en-us/articles/360024255514-What-are-the-system-requirements-for-Act-
09-12-2019 01:54 AM - edited 09-12-2019 02:00 AM
Yes to going to SQL standard edition but do consult the matrix in the above reply for which version is compatible with your version of ACT.
The big benefit is that SQL Express is restricted to a 10GB limit but standard is unrestricted and is also able to use more resources so better for multi user installations.
You will need this information to help you manually create the ACT SQL instance
09-13-2019 10:01 AM
09-18-2019 10:52 PM
Thank you, Mike and all the users who helped me in this regard.
I had already given my client the overview and now they have to decide if they really wanted to go with SQL server or reduce database.