For those of us extremely large files trying to trouble shoot our own issues it would be great if we could have the ability to extract our raw data into Access or SQL so we could run our own queries. I have 47,538 people in my tree with over 827,776 records and 29,897 media files. I'm having a sync failure I'm sure is related to a relationship issue, duplicate or media file. But short of tabbing through each and every media file I am unable to get to the root of the issue. Due to syncing this past month I have literally hundreds of missing media files, hundreds of duplicated people and I have no way to check the relationships although I've already found a few that needed to be fixed. The Sync feature of Ancestry is the bain of my existence. I spend more time fixing my file than working my genealogy.
And before you come back with a suggestion to use the "find duplicate people" option, I've tried that twice. It runs for hours and fails. A query would display the results and let me decipher. I've tried to run a report that shows me disconnected media files, it runs for hours and fails. Again, a query would show me results and let me decipher. At least I get to the heart of the matter without waiting for hours for a failure.
Tools to troubleshoot our own issues - it would help us and help Ancestry. Please.