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
520 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
4101 Points
3458 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
44321 Points
19115 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
520 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
44321 Points
19115 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>