Yes you can have multiple instances of Epicor. Allows for production and test DB. It allows replicating also…
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 11, 2014 9:34 AM To: vantage@yahoogroups.com Subject: [Vantage] Re: SQL Budgeting Cost for E10
Would it allow multiple instances of the Epicor databases? Would this SQL Runtime allow you to have your production and test databases on the same SQL server? As, I wouldn't think you'd want to purchase the runtime twice for testing. I wonder if it would
allow replication to the test DB too.
Small shop with 80 employees, running 9.05.702 on progress, 50 office 25 shop users, How much money should I budget for the SQL licensing cost for E10?
We just bought SQL for our E10 upgrade. Our up front software costs were around $3,500 (50 total users, it doesn't matter whether the user is MES or office, as far as SQL licensing is concerned). Our annual maintenance on SQL is roughly $1,500. Since you have 25 more users than us, I would budget about ~$5,300 for the software and ~$2,300 for annual maintenance.
Just for clarification, that is for the SQL Runtime (only sold through Epicor, as far as I know, and only licensed to work with Epicor and third-party, Epicor-related applications). The full version of SQL seems to be FAR more expensive.
Distributed partitioned views Yes Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial.
Jay- The SQL Runtime.. I'm assuming you're inferring that it does not include the standard SQL Server Management Studio? What limits are in place on the Runtime version? I quickly searched and didn't find anything but this article: http://support.microsoft.com/kb/917400
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] Sent: Wednesday, June 04, 2014 8:53 AM To: vantage@yahoogroups.com Subject: [Vantage] Re: SQL Budgeting Cost for E10
We just bought SQL for our E10 upgrade. Our up front software costs were around $3,500 (50 total users, it doesn't matter whether the user is MES or office, as far as SQL licensing is concerned). Our annual maintenance on SQL is roughly $1,500. Since you have 25 more users than us, I would budget about ~$5,300 for the software and ~$2,300 for annual maintenance.
Just for clarification, that is for the SQL Runtime (only sold through Epicor, as far as I know, and only licensed to work with Epicor and third-party, Epicor-related applications). The full version of SQL seems to be FAR more expensive.
It’s my understanding that the SQL runtime license includes everything SQL Standard contains. You just can’t create databases other than what would be used
for Epicor or Epicor related products.
Mike
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 04, 2014 8:19 AM To: vantage@yahoogroups.com Subject: RE: [Vantage] Re: SQL Budgeting Cost for E10
Jay- The SQL Runtime.. I'm assuming you're inferring that it does not include the standard SQL Server Management Studio? What limits
are in place on the Runtime version? I quickly searched and didn't find anything but this article:
http://support.microsoft.com/kb/917400
We just bought SQL for our E10 upgrade. Our up front software costs were around $3,500 (50 total users, it doesn't matter whether the user is MES or office, as far as SQL licensing is concerned). Our annual maintenance on SQL is roughly $1,500. Since you
have 25 more users than us, I would budget about ~$5,300 for the software and ~$2,300 for annual maintenance.
Just for clarification, that is for the SQL Runtime (only sold through Epicor, as far as I know, and only licensed to work with Epicor and third-party, Epicor-related applications). The full version of SQL seems to be FAR more expensive.
Just to contribute a few things that might not be general knowledge…
1.SQL 2012 R2 runtime is much cheaper than the full use license. The license is restricted for use with Epicor-provided applications and databases (yes, including extended UD fields and tables).
2.It is a good time to buy SQL Server *from Epicor*. As a promotion to support the Epicor ERP 10 release, Microsoft and Epicor have some discounted pricing for SQL Server (all editions and versions) though June, 2015. Talk to
your CAM for details. The special pricing is only good for SQL Server licenses purchased from Epicor.
3.Microsoft has DISCONTINUED the runtime license option for SQL Server 2014. However, customers with maintenance agreements for previous versions of SQL Server will be grandfathered into a full use license when they receive SQL 2014.
So to net it out, you might consider buying a runtime version of SQL 2012 R2 from Epicor ASAP and then requesting a maintenance upgrade (through your CAM) to SQL 2014, which would be a full use license at no additional charge.
Erik Johnson, Epicor
This message has been scanned for malware by Websense. www.websense.com
Are you looking to optimize E10 for SQL 2014, specifically the new cardinality estimator (http://msdn.microsoft.com/en-us/library/dn600374.aspx) and the xVelocity columnstore (http://blogs.technet.com/b/dataplatforminsider/archive/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance.aspx)?
I am under the same understanding as Mike, who already commented on this. I am VERY new to SQL, so I am far from an expert, but I believe that the Epicor SQL Runtime includes everything that you would get normally with a Standard SQL license and will do everything that you could normally do with a Standard SQL license, EXCEPT run a database that is completely unrelated to Epicor.
For us (and I would assume 90% of Epicor customers), that isn't an issue and is well worth the cost savings. If there is a chance that down the road, you will want to use the SQL licenses that you purchased for a different ERP or some other function completely unrelated to Epicor, the Epicor Runtime is probably not for you. Again, though, my understanding is that the Epicor Runtime of SQL is the most appropriate option in a vast majority of cases.
How exactly is this controlled or limited within the SQL version?
The license is restricted for use with Epicor-provided applications and databases (yes, including extended UD fields and tables).
Is it based on DB content? DB Name? Something else?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] Sent: Wednesday, June 04, 2014 2:09 PM To: vantage@yahoogroups.com Subject: [Vantage] Re: SQL Budgeting Cost for E10
Just to contribute a few things that might not be general knowledge…
1.SQL 2012 R2 runtime is much cheaper than the full use license. The license is restricted for use with Epicor-provided applications and databases (yes, including extended UD fields and tables).
2.It is a good time to buy SQL Server *from Epicor*. As a promotion to support the Epicor ERP 10 release, Microsoft and Epicor have some discounted pricing for SQL Server (all editions and versions) though June, 2015. Talk to your CAM for details. The special pricing is only good for SQL Server licenses purchased from Epicor.
3.Microsoft has DISCONTINUED the runtime license option for SQL Server 2014. However, customers with maintenance agreements for previous versions of SQL Server will be grandfathered into a full use license when they receive SQL 2014.
So to net it out, you might consider buying a runtime version of SQL 2012 R2 from Epicor ASAP and then requesting a maintenance upgrade (through your CAM) to SQL 2014, which would be a full use license at no additional charge.
Erik Johnson, Epicor
This message has been scanned for malware by Websense. www.websense.com
Just to contribute a few things that might not be general knowledge…
1.SQL 2012 R2 runtime is much cheaper than the full use license. The license is restricted for use with Epicor-provided applications and databases (yes, including extended UD fields and
tables).
2.It is a good time to buy SQL Server *from Epicor*. As a promotion to support the Epicor ERP 10 release, Microsoft and Epicor have some discounted pricing for SQL Server (all editions
and versions) though June, 2015. Talk to your CAM for details. The special pricing is only good for SQL Server licenses purchased from Epicor.
3.Microsoft has DISCONTINUED the runtime license option for SQL Server 2014. However, customers with maintenance agreements for previous versions of SQL Server will be grandfathered into
a full use license when they receive SQL 2014.
So to net it out, you might consider buying a runtime version of SQL 2012 R2 from Epicor ASAP and then requesting a maintenance upgrade (through your CAM) to SQL 2014, which would
be a full use license at no additional charge.
Erik Johnson, Epicor
This message has been scanned for malware by Websense.
www.websense.com
Epicor has a special runtime license agreement that is affordable.I think you will need the number of cores you are running as well.
Brenda J. Mohr
Humtown Products
44708 Columbiana-Waterford
Rd.
P.O. Box 367
Columbiana,
Oh 44408
Phone: 330
482-5555
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] Sent: Wednesday, June 04, 2014 8:44 AM To: vantage@yahoogroups.com Subject: [Vantage] SQL Budgeting Cost for E10
Small shop with 80 employees,running 9.05.702 on progress, 50 office 25 shop users, How muchmoney should Ibudget for the SQLlicensing cost for E10?
Would it allow multiple instances of the Epicor databases? Would this SQL Runtime allow you to have your production and test databases on the same SQL server? As, I wouldn't think you'd want to purchase the runtime twice for testing. I wonder if it would allow replication to the test DB too.
