trinityr (2/25/2014) Is there a way to 'flip' databases? Meaning we use SnapshotDB1 for data reporting until SnapshotDB2 is fully populated then use SnapshotDB2.
You can do this by "queuing" database snapshots.
You would need a logical database with a collection of views and a stored proc which dynamically regenerates the views when a new snapshot becomes available. There would always be a small lag in data but you could easily do this every 15 minutes or less.