Solved

MS SQL Licensing question

Posted on 2011-09-09
4
335 Views
Last Modified: 2012-05-12
From what I understand SSIS does not come with SQL Express (can someone confirm this?)
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26340644.html
What are the licensing requirements for MS SQL Standard for an application that will have one administrator. I will need the SSIS component and as far as I know I will need minimum the std edition in order to have the SSIS option

The App that will connect to SQL is for an eCommerce Magento connection to upload and download data. One administration and connection to a pervasive database with SSIS

Can someone give me an idea as to license requirements and cost as well for MS SQL for the above app?
0
Comment
Question by:Gerhardpet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36513369
Thats right the express edition doesnt support SSIS

Best bet would be  sql server 2008  standard edition and  it will cost around 8,000 per processor
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36513381
If it doesnt exceed 5 CAL then its around $1500 per license.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 36514804
Do you know if the Workgroup edition comes with SSIS?

When I do a quote on MS website I get the following. I don't even see the workgroup edition. I'm not sure but does the first option come with 5CAL's? I don't see any option to select the CAL's?
SQL LIcense
0
 
LVL 8

Accepted Solution

by:
venk_r earned 500 total points
ID: 36514949
Well, the workgroup has only limited features as far as SSIS is concerned.I think its limited to just import export options.If you want more than that then SQL Standard edition is best choice.The one mentioned $1199
I beleive is for just 1 server. If ypu need addition CAL's then it will be more.The one mentioned as $9500 iI believe is for 1 processor with unlimited CAL's.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question