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
keplanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.

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.