Merge 3 database

[former_member197621]

Dear all,

We are using

Database1-Chennai,

Database2-PONDI,

Database3-MUMBAI

now we want to take consolidate balance sheet for this 3 unit in chennai server,how to achieve this with out ADD-On's

[Former Member · Accepted solution]

Hi,

You have a few options:

If all 3 databases have different account numbers, (eg: 3000 in db 1 is bank, 3000 in db2 is revenue), then you can:

- create a dummy company that has a proper set up account structure

- in db 1, db 2 and db 3, chart of account, make use of the external account field or UDF to indicate which accounts they map to in the dummy company.

Example: 3000 (bank account) in db 1 is mapped to 3100 in the dummy. 3200 (bank account) in db2 is mapped to 3100 in dummy.

Once you have the structure set up, you can:

- create SQL views to combine information from all 3 databases and use crystal report to write the consolidated balanace sheet; or

- you can write the balance sheet with standard format using Excel, or XL reporter , you will have one balance sheet for each company then the consolidated balance sheet is simply adding up the 3 worksheets.

Good luck.

[former_member197621 · Accepted solution]

Hi

We are using same account code for 3 branches, as per your solution i want to restore daily other two database in head office?? then i have to run a XL-Reporter???

[Former Member · Accepted solution]

No, you do not restore databases.

with all your databases using same account codes, you can do as Neetu suggested with SQL procedure.

In other words, the simple way will be:

1. either you create views or SQL procedure to combine data from all three databases; or

2. you can create an XL report in the format that can run for all there databases and then use excel to consolidate them.

Edited by: Shwu Hua Gan on May 21, 2010 11:36 AM

[Former Member]

Hi,

Or you can use Power OLAP (Paris technologies). This is a wonderful tool!

Regards

Carin

[Former Member]

Hi,

If All the DB have the Same Chart of Account Wrtie a query to consolidate all the 3 Db and design a the Balance Sheet in Crystal report.

This is the only way.

Regards

Chidambaram

[former_member206488]

Dear,

create a procedure in SQL server to get the data from 3 different databases and use that procedure in crystal report to generate consolidated balace sheet.

Hope this will help u.

Thanks,

Neetu