Doubts on SQL Server based Application Architecture

� 

Hi All,

� 

My Application:

I am currently working on� a SQL Server based application. Therein we receive some business data from both internal legacy applications and external vendors as well. For this we use BizTalk which receives XML from various sources and pushes data into my application which then gets processed herein. This is a huge application which contains more tthan 250 tables with around 110 views and around 325 + SPs and functions. Also the application supports its web interface and SSRS based reporting. The processing is wired around scheduled jobs and SSRS subscriptions

� 

The data from the external sources may not be upto the mark hence we use a complex model of some source tables where BizTalk dumps the data which is validated and then valid records are moved to another model of similar tables structures an ...