3 database into 1 database

vikas

Hi All,

We have a situation wherein we have to propose a architecture to a customer. Customer maintains three different databases around three different locations. Now he wants to consolidate all the transaction happening in 3 different databases into 1 database and take the reports.

Can we use BizTalk Server or SQL Mirroring...

comments will be greatly appreciated

Thanks in advance,
Vikas

ara3n

Navision has consolidation at GL Level. Create a new company at HeadQuarters and Export the GL entries from the 3 databases and import them into the new consolidation. You can autmate the process if you want. You can use Biztalk if you want but it's not necessary. Basically you'll use Biztalk for delivery.