Epicor on SQL Server Management Studio?

Microsoft does have a free versions of SQL Server Management Studio
Express that can connect to various versions of SQL.

http://www.microsoft.com/en-us/download/details.aspx?id=7593 is one example.

Mark W.

On Thu, May 9, 2013 at 3:24 PM, Tanya Denison <tdenison@...> wrote:
> Management Studio is just a tool for accessing the database, it’s not a
> licensing option. If you purchased the Runtime license, you would not be
> able to use the database for anything other than base Epicor, which it
> sounds like you want to do. http://support.microsoft.com/kb/917400
>
>
>
> *Tanya Denison* | IT Manager | NRS, Inc.
>
> *2009 S. Main Street, Moscow, ID 83843*
>
>
>
> *tdenison@... *|* www.nrsweb.com*
>
> *c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
>
>
>
> *From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
> Of *todd@...
> *Sent:* Thursday, May 09, 2013 11:23 AM
> *To:* vantage@yahoogroups.com
> *Subject:* [Vantage] Epicor on SQL Server Management Studio?
>
>
>
>
>
> We are in the process of planning a full reimplementation, going from
> Vantage 6.1 to E9. Because we have developed several rather complex
> external "applications" in both MS Access and SQL Server (free version)
> that extract data from Vantage via ODBC, it is our belief that we should
> switch from a Progress backend to SQL Server, so that we can migrate these
> applications accordingly.
>
> Epicor is quoting us SQL Server "Runtime", which I don't think gives us the
> full suite of tools that would be available in SQL Server Management
> Studio.
>
> Has anyone else out there installed Epicor in conjunction with SQL Server
> Management Studio as I've described? Any issues/concerns?
>
> Thanks
> Todd Gilbert
> MASS Precision, Inc.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> 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
>
>
>
We are in the process of planning a full reimplementation, going from Vantage 6.1 to E9. Because we have developed several rather complex external "applications" in both MS Access and SQL Server (free version) that extract data from Vantage via ODBC, it is our belief that we should switch from a Progress backend to SQL Server, so that we can migrate these applications accordingly.

Epicor is quoting us SQL Server "Runtime", which I don't think gives us the full suite of tools that would be available in SQL Server Management Studio.

Has anyone else out there installed Epicor in conjunction with SQL Server Management Studio as I've described? Any issues/concerns?

Thanks
Todd Gilbert
MASS Precision, Inc.
Double check and ensure nothing has changed in the E9 model, but when I have
bought Vantage SQL versions in the past (8.03.xxx), it comes with everything
SQL including the Mgmt Studio. That should be a question your CAM can
easily answer, if not, ask your CAM to email Ben Nixon inside Epicor.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
todd@...
Sent: Thursday, May 09, 2013 2:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor on SQL Server Management Studio?





We are in the process of planning a full reimplementation, going from
Vantage 6.1 to E9. Because we have developed several rather complex external
"applications" in both MS Access and SQL Server (free version) that extract
data from Vantage via ODBC, it is our belief that we should switch from a
Progress backend to SQL Server, so that we can migrate these applications
accordingly.

Epicor is quoting us SQL Server "Runtime", which I don't think gives us the
full suite of tools that would be available in SQL Server Management Studio.


Has anyone else out there installed Epicor in conjunction with SQL Server
Management Studio as I've described? Any issues/concerns?

Thanks
Todd Gilbert
MASS Precision, Inc.





[Non-text portions of this message have been removed]
I just looked at our docs and we have SQL Enterprise Runtime. It has SQL Studio and can do any stored procs, etc you would want.

Greg Payne

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of todd@...
Sent: Thursday, May 09, 2013 2:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor on SQL Server Management Studio?



We are in the process of planning a full reimplementation, going from Vantage 6.1 to E9. Because we have developed several rather complex external "applications" in both MS Access and SQL Server (free version) that extract data from Vantage via ODBC, it is our belief that we should switch from a Progress backend to SQL Server, so that we can migrate these applications accordingly.

Epicor is quoting us SQL Server "Runtime", which I don't think gives us the full suite of tools that would be available in SQL Server Management Studio.

Has anyone else out there installed Epicor in conjunction with SQL Server Management Studio as I've described? Any issues/concerns?

Thanks
Todd Gilbert
MASS Precision, Inc.


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
Management Studio is just a tool for accessing the database, it�s not a
licensing option. If you purchased the Runtime license, you would not be
able to use the database for anything other than base Epicor, which it
sounds like you want to do. http://support.microsoft.com/kb/917400



*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, ID 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*



*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *todd@...
*Sent:* Thursday, May 09, 2013 11:23 AM
*To:* vantage@yahoogroups.com
*Subject:* [Vantage] Epicor on SQL Server Management Studio?





We are in the process of planning a full reimplementation, going from
Vantage 6.1 to E9. Because we have developed several rather complex
external "applications" in both MS Access and SQL Server (free version)
that extract data from Vantage via ODBC, it is our belief that we should
switch from a Progress backend to SQL Server, so that we can migrate these
applications accordingly.

Epicor is quoting us SQL Server "Runtime", which I don't think gives us the
full suite of tools that would be available in SQL Server Management
Studio.

Has anyone else out there installed Epicor in conjunction with SQL Server
Management Studio as I've described? Any issues/concerns?

Thanks
Todd Gilbert
MASS Precision, Inc.




[Non-text portions of this message have been removed]