Solved

Microsoft Datawarehouse Hardware Architecture and Software licencing

Posted on 2012-03-21
4
359 Views
Last Modified: 2012-04-04
Dear All,

I am developing project plan for our new Datawarehouse  on Microsoft 2008 R2 plat form.
Our organization need minimum requirments in order to run the Datawarehouse.
It is like One dedicated server for ETL jobs and production databases and one dedicated server for Development, Testing, staging.

Can anybody give me some Microsoft licencing requirments in order to run the Datawarehouse as I explained above.

Thanks for your help
0
Comment
Question by:keplan
[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
  • 2
  • 2
4 Comments
 
LVL 81

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 500 total points
ID: 37755154
new Datawarehouse please explain this?

what is your current infastructure?

2 x Sql Server Standard and 2 X Server 2008 Standard.  You might be able to use sql express depending upon your requirements and how the data is accessed. How many clients?
0
 

Author Comment

by:keplan
ID: 37755398
nothing at the moment,
what I need to get clear here is to what we need in term of lecencing developing enviroments, and production and test(in a one box) and in production what we need in order to run ETL jobs and host the production SQL database.

for development enviroment, we need to develop SSIS packages and test them in the same box. Becouse of budgeting we are going with one single server for development(virtual) and one physical box for production databases and ETL jobs.
0
 
LVL 81

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 37755531
for virtual machines go with microsoft server enterprise as it comes with 4 virtual machine licenses.. if this is a new business you might consider signing on with Microsoft BizSpark
0
 

Author Comment

by:keplan
ID: 37764039
in a production server, i need to have production database and nightly ETL jobs (SSIS)runs as Agent jobs, so could you please let me know what is minimum licency requirments for this.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

717 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