<div>
Imran,<br />
<br />
1. Any comments/suggestion on above design.<br />
Why not use SQL Server 2005 replication in stead of &quot;a service that will fetch the data from transactional database, compile it, and dump into the reporting database&quot; ? It's perfect for the job described and does all the error handling and other stuff for you. Note that you do NOT want mirroring, replication is the feature you need.<br />
<br />
2. Any other better idea for load balancing for the above situation.<br />
No, that is the it should be done ! I've set up this scenario many times, and it works like a charm.<br />
<br />
Hope this helps ...<br />

</div>


Imran,

1. Any comments/suggestion on above design.
Why not use SQL Server 2005 replication in stead of "a service that will fetch the data from transactional database, compile it, and dump into the reporting database" ? It's perfect for the job described and does all the error handling and other stuff for you. Note that you do NOT want mirroring, replication is the feature you need.

2. Any other better idea for load balancing for the above situation.
No, that is the it should be done ! I've set up this scenario many times, and it works like a charm.

Hope this helps ...


<div>
Yveau, thanks for your input.<br />
<br />
I have a few questions on replication:<br />
<br />
1. What type of replication will fit for this scenario ? <br />
2. Does replication supports operations on data prior to dump into another database ?<br />
<br />
Imran<br />
<br />
<br />
<br />

</div>


Yveau, thanks for your input.

I have a few questions on replication:

1. What type of replication will fit for this scenario ?
2. Does replication supports operations on data prior to dump into another database ?

Imran





<div>
I just got comments on what I was designing, no new ideas for which I was looking for. Anyhow, this was quite helpful.
</div>


I just got comments on what I was designing, no new ideas for which I was looking for. Anyhow, this was quite helpful.

<div>
<div class="content wysiwyg-content">
Please refer to this thread:<br />
<br />
<a href="https://www.experts-exchange.com/questions/22962961/Database-Design-for-a-data-extensive-application.html" rel="ugc">https://www.experts-exchange.com/questions/22962961/Database-Design-for-a-data-extensive-application.html</a><br />
<br />
Imran
</div>
</div>


Please refer to this thread:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22962961.html

Imran

Database Design for a data extensive application

Project management is the discipline of carefully projecting or planning, organizing, motivating and controlling resources to achieve specific goals and meet specific success criteria. A project is a temporary endeavor designed to produce a unique product, service or result with a defined beginning and end (usually time-constrained, and often constrained by funding or deliverables) undertaken to meet unique goals and objectives, typically to bring about beneficial change or added value.

Project Management

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Programming theory deals with the design, implementation, analysis, characterization, and classification of programming languages and their individual features, along with introductory programming concepts like program structure, variable declaration and conditional and looping constructs. Sub-disciplines include the formal semantics of programming languages, type theory, program analysis and transformation, comparative programming language analysis, metaprogramming, domain-specific languages, compiler construction and run-time systems.