Robert Gama

Robert Gama

  • NA
  • 12
  • 1.9k

Need integration Postgres and SQL Server update if exists

Sep 3 2019 12:04 AM
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.
 

Answers (1)