In this session, Gabby, an Enterprise Technical Support Advisor at Quest, discusses the critical topic of Autosync in SharePlex, a database replication tool. The session covers four main areas: defining Autosync, understanding why data goes out of sync, identifying these issues, and methods to resolve them. Autosync occurs when there is a mismatch between the source and target databases, often due to conflicting updates or various causes like triggers, constraints, and user permissions.
Gabby explains how SharePlex detects Autosync conditions through logs and commands, emphasizing the importance of early identification to maintain data integrity. The session also introduces powerful utilities like the Compare and Repair commands, which help detect and correct discrepancies between source and target databases. Gabby highlights best practices for using these tools, including scheduling regular compares and ensuring all necessary processes are running.
The presentation concludes with a summary of the key points discussed, encouraging participants to ask questions and attend future sessions for more insights on SharePlex best practices.
For additional SharePlex 101 Skills videos, please visit our website at https://www.quest.com/data-management-skills-training/shareplex-skills-101-webcast-series-on-demand.aspx
To participate in our upcoming Skills 101 series, please visit: https://www.quest.com/skills-101-training/
