thnx for the reply, this involves a lot of calculation from multiple tables.

The database contains approx 260 tables and what we need is the data from appox 150 tables. Is ssis packages are good solution if we use separate db's and then sych them.?

Thnx for your reply, but what if the Database grows big coz of the data and the client. Also the backup will also become an issue due to larger size. All the users databases are also managed by us.

hi to all, I have an application that requires a lot of calculation, there are a lot of clients that uses that application having separated DB’s. Now I am going to develop another web-application that will get the records of all those databases and on the basis of filter will display the results. I want to ask you a question that 1. Should I change the structure of the application in which all of my clients share a same database and from where I could get all the records I needed and perform calculation on them? 2. Would I keep the all databases separate (as it is condition) and develop a service that will fetch the records from the entire database into one from where I would perform my calculation and display the data. Do also tell me if there is some other solution to this application architecture.