April 20, 2010 at 9:10 pm
Say I have two databases:
bank_db1 and bank_db2
Now, I need to merge these two databases. These two databases might have common fields and entries which must be merged properly.
For example:
Client A has a loan of $100 from bank B1 and
Client A has a loan of $50 from bank B2, then the resulting bank_db should have client A with a loan of $150.
Any help would be highly appreciated.
Thanks ya'll.
April 20, 2010 at 9:39 pm
You can't merge databases. You can merge the data in the tables, but there could be different logic for every table.
In terms of what you are doing with these tables, you'll need to write a query that compares credit and debit logic between the tables and does a sum with all the data for each client.
April 21, 2010 at 6:51 am
jaideep.balekar (4/20/2010)
Any help would be highly appreciated.
Something tells me there are two databases because there are two different applications and two different sets of business rules.
Integrating systems is not a any-other-day activity - I would strongly suggest to hire a senior PM with experience in systems integration and put togheter a proper plan.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply