?
Solved

Microsoft Datawarehouse Hardware Architecture and Software licencing

Posted on 2012-03-21
4
Medium Priority
?
361 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 82

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 1500 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 82

Accepted Solution

by:
David Johnson, CD, MVP earned 1500 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

752 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