Is it possible to Update/Save new Record on databaseA on ServerA when databaseB on ServerB is updated?

Question

I have this requirement that i need to Update/Save all records from DatabaseA on ServerA when DatabaseB on ServerB Status is updated to FG-FRESH.

Example:

ServerB| DatabaseB

SerialNumber Status 0000001 Completed 0000002 FG-FRESH 0000003 FG-FRESH

ServerA | DatabaseA

SerialNumber Status 0000002 FG-FRESH 0000003 FG-FRESH

So if SerialNumber 0000001 is Updated to FG-FRESH on ServerB it will also be inserted to ServerA |DatabaseA just clicking a refresh Button.

I will create the application using winform in c#.

Is it Possible? I really need your Help..Thanks in Regards..

Answer 1

So if SerialNumber 0000001 is Updated to FG-FRESH on ServerB it will also be inserted to ServerA |DatabaseA just clicking a refresh Button.

so you want this to happen in response to a button being clicked?

Answer 2

maybe an SQL trigger is what you're looking for

Here

When an insert or update happens on a table in one database, you can update another table in another database with the info.

Answer 3

What you looking for is Replication. This is the feature that allows changes on one database to be propagated to a different database. There are various flavors of replication (Merge, Transactional, Peer-to-Peer etc). Which is the right one depends on many factors, see Selecting the Appropriate Type of Replication.

Answer 4

You can also use the Sync Framework. Set up the synchronization as unidirectional and use the click on the button as the trigger.