Preserving full refresh data source
ALTER TABLE ... SWITCH would allow you to switch in each table when you want to change the &quot;live&quot; table.  The only requirement is to ensure both tables involved in the switch are in the same filegeoup, and have the same structure.