Solved

Microsoft Datawarehouse Hardware Architecture and Software licencing

Posted on 2012-03-21
4
355 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 80

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 80

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Microsoft Dynamics Roles question 4 125
Numerous files can not be opened anymore 17 71
What .NET website keeps me current? 9 80
Input parameteres to DragOver 2 38
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…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

726 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