Question

Can RIO licensed servers use SQL express?

Laserfiche Version 8 Version 9 Licensing

Updated December 12, 2013

asked on December 10, 2013

We have a client where they have several sites that used to use 1 Centrally located LF server using Standard SQL and Laserfiche Standard system. Now they're upgrading to RIO and each location will be getting their own LF server instance instead of sharing, as well as having their own SQL. Are some of these sites able to use SQL express as their DBMS or will each location be required to purchase and use Standard SQL since that was their previous licensing model?

0 0

Answer

APPROVED ANSWER

replied on December 10, 2013 • Show version history

There isn't anything on the Laserfiche Rio side that would prevent using SQL Express instead of full SQL. I would primarily be worried about the limitations imposed by SQL Express. Last time I checked, it can only use 1 processor (socket) and up to 1 GB of RAM. The RAM especially can become a bottleneck real quickly if there's a lot of activity in the system.

You may want to evaluate the workloads on their current repositories now and decide which ones should stay on full SQL and which ones can be downgraded to SQL Express.

0 0

Replies

replied on December 12, 2013

http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

This is the link to a chart listing features and limitations by MS SQL server product.

1 0

You are not allowed to follow up in this post.

Question

Question

Can RIO licensed servers use SQL express?

Answer

Replies

Sign in to reply to this post.