locked
Sncyronise data and structure of 2 tables continiously RRS feed

  • Question

  • User283528319 posted

    Hi all,

    I plan 2 dbs to share 5 data tables and I want to snyc them continiously (when ever one is changed (as structure and data) the other also should be synchronise.

    Btw changes are very rare

    Monday, July 29, 2019 5:05 AM

Answers

  • User475983607 posted

    I plan 2 dbs to share 5 data tables and I want to snyc them continiously (when ever one is changed (as structure and data) the other also should be synchronise.

    Btw changes are very rare

    Use a trigger to synchronize data if the databases are on the same server.

    You'll need to update the DDL if the structure changes.

    IMHO, this requirement points to a questionable design.  

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 29, 2019 11:12 AM

All replies

  • User1120430333 posted

    That depends on what database you are using as to what you can do.

    Monday, July 29, 2019 8:43 AM
  • User475983607 posted

    I plan 2 dbs to share 5 data tables and I want to snyc them continiously (when ever one is changed (as structure and data) the other also should be synchronise.

    Btw changes are very rare

    Use a trigger to synchronize data if the databases are on the same server.

    You'll need to update the DDL if the structure changes.

    IMHO, this requirement points to a questionable design.  

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 29, 2019 11:12 AM
  • User283528319 posted

    IMHO, this requirement points to a questionable design.  

    what kind of questions do you have in your mind?

    Monday, July 29, 2019 9:54 PM
  • User475983607 posted

    what kind of questions do you have in your mind?

    Generally, duplicate data  and syncing data causes unnecessary complexity.  

    Tuesday, July 30, 2019 12:05 AM