_ian Posted November 9, 2020 Share Posted November 9, 2020 (edited) We've been doing a one-way sync from FileMaker Server to a data warehouse on SQL Server for years. MirrorSync runs every 15 minutes to pump the data from FileMaker tables to SQL Server tables. We'd like to archive records in the FileMaker system but retain them in the data warehouse. This is primarily for performance and usability reasons. The FileMaker users have no need to refer to the records that are more than 5 years old, of which there are a few hundred thousand. Hence, we'd like to archive them, but the finance team doesn't want to lose them out of their data warehouse. Is there a way to remove the records from FileMaker while retaining them in the data warehouse? Ideally we'd have a sync that didn't replicate the deletions, but then return to business as usual after that sync was done. ETA: Sorry i'd not read the prior post, which sounds quite pertinent. I'll look into the selection criteria through the script as that may be able to accommodate our needs. Edited November 9, 2020 by _ian Link to comment Share on other sites More sharing options...
This topic is 889 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now