How to keep tables synchronized in different database?

3

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).

    
asked by anonymous 23.07.2018 / 22:54

0 answers