Hi all

I have one customer where I have one DB by each customer of my main customer, but my main customer want's centralize the data of all his customers and like this my main customer can watch the information of his customers ...

I was thinking on implementation of mirroring but some one told me that when the data being updated perhaps information can be lost (because the data bases of the customers of my customer have the same structure)...

which practice apply to this escenario ??

Generally, you would need to create a schema for each customer within a database and reference it,

SELECT * FROM cust1.Orders

SELECT * FROM cust2.Orders

.....

1) Keep centralize database in separate database

2) make changes on it 

3) once required use those in other database and  keep copy  job to other database