All geek questions in one place

Synchronization of two heterogeneous databases

I have 2 heterogeneous databases. One in mysql and one in ms sql.

I want them to sync.

The data stream will periodically arrive, and the information stream will be in both directions

Has anyone got any strategies / approaches to it?

+3
source share
4 answers

Assuming that you are not going to use any form of turnkey solution, you have several options for you. Basically what you are trying to do is find a way to capture changes made in one database and replicate them to another database.


, , , , . , , ,

  • Pro: .
  • Pro: .
  • : .
  • Con: .

.


, , , .

  • Pro: ,
  • Pro:
  • Con: . , .

, , .


.

  • Pro: , .
  • Con:


, .

  • Pro: .
  • Con: . , , - , .

, (.. , ). (.. / /ad -hoc) .

+2

, Google.

sync mysql mssql

,

0

:

  • ? 5 ? 5 ? 15 ? ..
  • ? , , - ?
  • ? , , ?
  • concurrency? ?
  • ?
  • ? , , , , - ?
  • ? , , ( 5 )?

, , . ( ). , . , .

, , ETL. , . , - , . , . , Adam Luchjenbroers ETL. , , , , , .

0

synchrodb.com

SynchroDB .

SynchroDB .

SynchroDB . :

• , .

• , , , .

• , .

SynchroDB .

0

Source: https://habr.com/ru/post/1725526/

More articles:


All Articles