AnsweredAssumed Answered

PSoS Import Records Update Matching Delete deleted from Target

Question asked by petermac on Feb 2, 2017
Latest reply on Feb 2, 2017 by petermac

I am looking for a way to complete a one way synchronization.  I have a SQL database containing all the equipment that we have out on rental.  I Update the Filemaker database nightly with a Perform Script on Server.  It works wonderfully but I cannot figure out how to delete the records from the Filemaker database that have been deleted in the SQL database.  This script works perfectly except when fired up with a Perform Script on Server.

 

Import Records (with dialog:Off; DSN; ............ Update matching; Windows ANSI]

Show Omitted Only

Delete All Records [with dialog:off]

 

Is there some way to make a one way sync work?

 

Thanks,

Peter

Outcomes