where to install the new warehouse SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » where to install the new warehouse SQL Server...

where to install the new warehouse SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

aman_work

Posted Sunday, January 27, 2013 3:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, February 17, 2013 1:49 AM
Points: 2, Visits: 24

I’m starting to build the DM design for BI data warehouse; I have two SQL server 2008 databases that will create the ETL to read from them what is the best physical structure I should consider? Should I create the new database warehouse on the same source database server? or should I install new SQL server instance for the warehouse database ? Or should I install MS SQL Server 2008 on the same server where my BI server is and create the database there? Which choice will be better for ETL best performance? by the way, my company bought Pentaho System for BI

Post #1412114

Koen Verbeeck

Posted Monday, January 28, 2013 5:51 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495

Please do not crosspost. It wastes people's time and fragments replies.

Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1412112-147-1.aspx

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1412375

« Prev Topic | Next Topic »

Permissions