2 Replies Latest reply on Feb 2, 2017 8:07 AM by petermac

    PSoS Import Records Update Matching Delete deleted from Target

    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