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.
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.
Member
90 Points
519 Posts
Sncyronise data and structure of 2 tables continiously
Jul 29, 2019 05:05 AM|fatihbarut|LINK
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
Contributor
4433 Points
3754 Posts
Re: Sncyronise data and structure of 2 tables continiously
Jul 29, 2019 08:43 AM|DA924|LINK
That depends on what database you are using as to what you can do.
All-Star
47311 Points
20713 Posts
Re: Sncyronise data and structure of 2 tables continiously
Jul 29, 2019 11:12 AM|mgebhard|LINK
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.
Member
90 Points
519 Posts
Re: Sncyronise data and structure of 2 tables continiously
Jul 29, 2019 09:54 PM|fatihbarut|LINK
what kind of questions do you have in your mind?
All-Star
47311 Points
20713 Posts
Re: Sncyronise data and structure of 2 tables continiously
Jul 30, 2019 12:05 AM|mgebhard|LINK
Generally, duplicate data and syncing data causes unnecessary complexity.
</div>