After trying a test OpenQuery on a table and seeing how slowly it ran, that's definitely my plan!

I think I'll have a daily rebuild and then build packages to run throughout the moving over the updates and changes.