• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Microsoft Datawarehouse Hardware Architecture and Software licencing

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
keplan
Asked:
keplan
  • 2
  • 2
2 Solutions
 
David Johnson, CD, MVPOwnerCommented:
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
 
keplanAuthor Commented:
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
 
David Johnson, CD, MVPOwnerCommented:
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
 
keplanAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now