Need integration Postgres and SQL Server update if exists

Question

Hello friends, good night.
I wonder if anyone can help me with this doubt.

I have 2 databases (SQL Server) X and another POSTGRES Y.

Well, I need you to enter a particular row in a Postgres Y table, automatically check if there is this same record in the X table of SQL Server, if there is no record then copy/update.
If the registration already exists, then do not copy.

Because I have two systems that need integration.

 

Example:

 

P o s t g R e s         SQL Server
People people     
Name Name
Phone Phone

"Roger ", "12345 "

 

Please help, some script or solution that can do that.

Thank you.

 

Answer 1

Dear,

 

If you follow the repository pattern then its make your life easy.

Make two Repository and call same in Services so you can make two insterts or update at same time.

 

Thanks

Dharmesh Sharma