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
92 Points
534 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
4923 Points
4203 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
53021 Points
23607 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
92 Points
534 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
53021 Points
23607 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>