troubleshooting Question

SQL and duplicate records

Avatar of wesbrowning
wesbrowning asked on
FileMaker Pro
7 Comments1 Solution921 ViewsLast Modified:
I've recently set up a ODBC connection to our webhost's SQL server. For a web application that they've built for us, they're writing data to it that get's over-written by users as they come in and update their data. What we'd like to do is query the server every 5 minutes (we have a script and the eSchedule database doing that automatically) and get the latest data. However, we'd like to preserve a history of all records. Ideally, it would be best I could create a script that went and got the recrods that have changed (and new ones) and download those. We would base all of our reporting off of that customer's latest record, and we'd just want the history as a way to refer to what they've done. I know how to do matching, updating, etc. during import-- but I'm not sure if there's a way to utilize those functions during the import process. I'm trying to avoid downloading all the records every 5 minutes (as that would be one possible solution). Any thoughts?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros