Info Small business ERP server hosted locally?

[tijag]

Hello,

Currently we are using cloud hosted ERP in a multi-tenant situation. Owners of the company want to move away from the monthly cost of the system, so I'm exploring what it would take to put our ERP on a local server.

The main issue is no one in the company is proficient at Windows Server or SQL Server.

Our license for ERP allows for 5 concurrent users at a time, but we have probably like 10 unique users that all use several devices.

I have many many questions but first off, we aren't interested in developing or doing anything to the software anymore. We have it where we want it, and now we just want it to run going forward. Assuming we get the server setup and our database transferred, beyond setting up a regular offsite backup in addition to the raid 10 for the database, we should be pretty good to have it just set to run without much problems, right? I'm expecting we'd need to higher a consultant for the setup, but then after that i would expect we would rarely need expert intervention.

Second question is more related to pricing. What kind of licensing do I need for Windows Server and SQL Server.

Probably looking at a 1 socket AMD Epyc server, one of their mid-range 16 core 32 thread versions [whichever is best value when we get to that stage].

Thanks in advance!

 

[sdifox]

Name of product? Running an ERP for ten users is kind of a waste. How big is the db?

 

[tijag]

Epicor, dunno how big the db is, hosted on their servers and i don't know that i could check it. small company but fairly complicated. we have lots of various kinds of transactions and also full manufacturing. 'next steps' for using the software will be to incorporate barcodes into our travelers so that jobs going through the shop can show in real time where they are. but that is not currently implemented yet.

 

[sdifox]

Epicor, dunno how big the db is, hosted on their servers and i don't know that i could check it. small company but fairly complicated. we have lots of various kinds of transactions and also full manufacturing. 'next steps' for using the software will be to incorporate barcodes into our travelers so that jobs going through the shop can show in real time where they are. but that is not currently implemented yet.

If you don't know the db size or load requirement, how are you going to spec a server? Also, for ten users I doubt you need more than a sqlserver standard edition, but the issue is sqlserver licencing is expensive.

https://www.microsoftvolumelicensing.com/Downloader.aspx?documenttype=PT&lang=English

 

[tijag]

If you don't know the db size or load requirement, how are you going to spec a server? Also, for ten users I doubt you need more than a sqlserver standard edition, but the issue is sqlserver licencing is expensive.

https://www.microsoftvolumelicensing.com/Downloader.aspx?documenttype=PT&lang=English

I'm going based off of the recommended hardware from the vendor.

Was planing on a 250 - 500 GB SSD for boot drive and then 4x500gb SSDs in a raid 10 which is like 900g of storage. thats more than enough space for us.

 

[mxnerd]

Don't think you can find any ERP system that does not require monthly/yearly fee.
Accounting/manufacturing alone need constant modification.

It's good if you can own your data locally, but you also need a good offline backup plan. To transfer from one system to another will cost you a fortune however.

For a small business under 10 users, EPYC CPU is way overkill and uses too much electricity. A modern i7 or even i5 CPU will last you for many years unless your business suddenly explodes.

NVMe Raid 1 is good enough and don't bother with SSD raid 10 which doesn't make any sense in your environment. Besides, raid is for uptime, not for backup.

Windows 2019 Essentials will be perfect for small business and you do not need CAL for each user. I still recommend Intel CPU for compatibility.

If you don't want to pay for MS SQL Server, you need to find ERP systems that use MySQL/PostgreSQL.

==

https://wiki.postgresql.org/wiki/Ecosystem:Enterprise_resource_planning_(ERP)

 

[sdifox]

Don't think you can find any ERP system that does not require monthly/yearly fee.
Accounting/manufacturing alone need constant modification.

It's good if you can own your data locally, but you also need a good backup plan.

For a small business under 10 users, EPYC CPU is way overkill and uses too much electricity. A modern i7 or even i5 CPU will last you for many years unless your business suddenly explodes.

Windows 2019 Essentials will be perfect for small business and you do not need CAL for each user. I still recommend Intel CPU for compatibility.

If you don't want to pay for MS SQL Server, you need to find ERP systems that use MySQL/PostgreSQL.

==

https://wiki.postgresql.org/wiki/Ecosystem:Enterprise_resource_planning_(ERP)

Or he can use the Epyc server to host the different server VMs he needs for the ERP.