Problem
I have a problem where I need to synchronize some tables from one legacy database to another simpler database that will be used by an external application.
Attempts
So I started to look at manual techniques for managing change on both bases and replicating them in the others (and not meriting conflicts and merge).
But I realized that in some ways that I could model, they end up being prone to failures in some scenarios, not counting the amount of extra columns just to control the versions and audit the records.
Question
So I believe you have some approaches, techniques, and database modeling that will facilitate this work, and help you maintain up-to-date data in both databases, perhaps even predicting conflicts and merge .
Anything you can tell me? Something that works similarly for me?
Note: Integration can not be done through the database, it must be performed through webservices. Because they may be different databases.
My question is not about tools, but about a modeling that gives me a structure where I can get the records I have to send to the other database, with the least possible redundancy.
I accept suggestions for using the external database in non-relational structure (NoSQL).