Hi Ben,

1. Do you mean update lookups that used to point to lists.<list_name> to <external_schema>.<list_name>? We don't have a UI for bulk updating across lists and datasets. You could query directly against the Postgres database to at least track down the ones that need to be changed:

SELECT * FROM exp.propertydescriptor WHERE lookupschema = 'lists'

2. Query validation won't detect broken lookups, unless they're used as the special <table>.<column>.<lookup1>.<lookup2> syntax in custom queries. I can't think of any reasonably easy automated way to track them down.

Thanks,
Josh