We have 15-year-old SQL databases that still contain active records. Management won’t approve migration due to risk. How can I safely identify and archive obsolete entries? Need something that connects directly to legacy systems without requiring modern APIs. Visual workflow solutions?
Latenode’s legacy DB connector + AI analysis. We connected to 90s-era systems using ODBC, then used visual workflow to flag inactive records based on usage patterns. Exported archives automatically. No migration needed.
First create a read-only mirror. Use scheduled jobs to analyze last accessed dates and relationships. Trick is setting up safe deletion queues that require manual approval. We used Python scripts with Airflow, but visualization was challenging.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.