Epicor 9 SQL or SQLExpress

Just an addition to this thread. SQL 2008 is included with 9.05. You don't have to purchase it separate. If you want to test it ask your CAM for the SQL version of the 9.05 package.

--- In vantage@yahoogroups.com, "roadhazard6803" <roadhazard6803@...> wrote:
>
>
> Thanks to everyone who replied to my post.
> We've taken a step back to look at what we need now and are going to go forward when we have a list of the specs.
>
>
> --- In vantage@yahoogroups.com, "Chad" <csmith@> wrote:
> >
> > I've run a testing environment on SQL Express and it seemed to work ok. I wouldn't try running a production environment unless it's supported though.
> >
> > My understanding is that Epicor has recently started or expressed desire to support SQL Express for things like Enterprise Search and Advanced Financial Reporting. PURE SPECULATION: I suspect that sooner or later, we'll have official support for SQL Express and it would likely be fine for smaller environments.
> >
> > As mentioned already, the vast majority of Epicor functionality runs just fine (or better) on Progress.
> >
> > Also note, that for 9.05 you MUST have SQL 2008 if you are going the SQL route.
> >
> >
> > --- In vantage@yahoogroups.com, "roadhazard6803" <roadhazard6803@> wrote:
> > >
> > > Does any one know if you can use SQL express with E9 and the replication server instead of SQL?
> > > And by use I mean is it supported or documented?
> > > If any does, because of the cost, can we use SQL2003 or should we bite the bullet and go with 2008?
> > >
> >
>
Does any one know if you can use SQL express with E9 and the replication server instead of SQL?
And by use I mean is it supported or documented?
If any does, because of the cost, can we use SQL2003 or should we bite the bullet and go with 2008?
SQL Server Express only supports subscriber replication:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

You do however get SQL Server Reporting Services with the Express Edition.


Thanks,

Aaron Browne


Principal
Tel: (512) 694-2456
Email: aaron@...<mailto:aaron@...>
Web: www.reportingguru.com<http://www.reportingguru.com/>

ReportingGuru - The Reporting Experts!
Reporting Architecture, Crystal Reports, Business Objects, SQL Server Reporting Services, BIRT, Excel Pivot Tables, Custom Reporting Solutions



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of roadhazard6803
Sent: Wednesday, January 26, 2011 1:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 SQL or SQLExpress



Does any one know if you can use SQL express with E9 and the replication server instead of SQL?
And by use I mean is it supported or documented?
If any does, because of the cost, can we use SQL2003 or should we bite the bullet and go with 2008?



[Non-text portions of this message have been removed]
SQL 2003 is not supported with Epicor 9.

SQLExpress might work, but probably since I don't think has a full set of
capabilities, but it is also limited to a 10GB database, which for most
people is not enough.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
roadhazard6803
Sent: Wednesday, January 26, 2011 2:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 SQL or SQLExpress

Does any one know if you can use SQL express with E9 and the replication
server instead of SQL?
And by use I mean is it supported or documented?
If any does, because of the cost, can we use SQL2003 or should we bite the
bullet and go with 2008?



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Probably just a type but there is no such animal as SQL Server 2003.

Technically, depending upon the modules you intend to implement, SQL Server may not be a requirement at all. If you are implementing the core modules only you can run Open Edge and not have to pay for any database license.

Regards,

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

On Jan 26, 2011, at 2:58 PM, Ned wrote:

> SQL 2003 is not supported with Epicor 9.
>
> SQLExpress might work, but probably since I don't think has a full set of
> capabilities, but it is also limited to a 10GB database, which for most
> people is not enough.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> roadhazard6803
> Sent: Wednesday, January 26, 2011 2:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Epicor 9 SQL or SQLExpress
>
> Does any one know if you can use SQL express with E9 and the replication
> server instead of SQL?
> And by use I mean is it supported or documented?
> If any does, because of the cost, can we use SQL2003 or should we bite the
> bullet and go with 2008?
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>



[Non-text portions of this message have been removed]
I've run a testing environment on SQL Express and it seemed to work ok. I wouldn't try running a production environment unless it's supported though.

My understanding is that Epicor has recently started or expressed desire to support SQL Express for things like Enterprise Search and Advanced Financial Reporting. PURE SPECULATION: I suspect that sooner or later, we'll have official support for SQL Express and it would likely be fine for smaller environments.

As mentioned already, the vast majority of Epicor functionality runs just fine (or better) on Progress.

Also note, that for 9.05 you MUST have SQL 2008 if you are going the SQL route.


--- In vantage@yahoogroups.com, "roadhazard6803" <roadhazard6803@...> wrote:
>
> Does any one know if you can use SQL express with E9 and the replication server instead of SQL?
> And by use I mean is it supported or documented?
> If any does, because of the cost, can we use SQL2003 or should we bite the bullet and go with 2008?
>
Thanks to everyone who replied to my post.
We've taken a step back to look at what we need now and are going to go forward when we have a list of the specs.


--- In vantage@yahoogroups.com, "Chad" <csmith@...> wrote:
>
> I've run a testing environment on SQL Express and it seemed to work ok. I wouldn't try running a production environment unless it's supported though.
>
> My understanding is that Epicor has recently started or expressed desire to support SQL Express for things like Enterprise Search and Advanced Financial Reporting. PURE SPECULATION: I suspect that sooner or later, we'll have official support for SQL Express and it would likely be fine for smaller environments.
>
> As mentioned already, the vast majority of Epicor functionality runs just fine (or better) on Progress.
>
> Also note, that for 9.05 you MUST have SQL 2008 if you are going the SQL route.
>
>
> --- In vantage@yahoogroups.com, "roadhazard6803" <roadhazard6803@> wrote:
> >
> > Does any one know if you can use SQL express with E9 and the replication server instead of SQL?
> > And by use I mean is it supported or documented?
> > If any does, because of the cost, can we use SQL2003 or should we bite the bullet and go with 2008?
> >
>