@mvdba Mike Vessey,

First, lol...love your opinion of SSIS, haha!  I'd love to introduce you to this product's database, it would make you love SSIS in contrast...

Regarding grouping into...

Great ideas and much appreciated...having the articles in place prevents the dropping of tables.  Not knowing which table is going to get dropped is the issue there...then when a table...

@Jeffrey Williams 3188...real time (or close-to-current) data is needed in a couple of places.  Of course, most users begin by saying yes they need real-time access, lol.  I believe we...

The table drops and recreates and so forth are controlled by a vendor application.  Size varies, though not large in affected areas, I believe.  The tables may be the same...

Hi Jeffrey Williams 3188,

A read-only version that can be accessed without affecting production.

Transactional replication was my first desire, but due to constraints in the product that's not doable without causing...

Ahhh, it appears it's available in standard, but only as a non-readable...either need to upgrade SQL or look elsewhere.

Thanks again for the direction, that provided a lot of good ideas

Thank you very much, I had not looked into that before.  Is that available in the SQL Standard edition?  I am reading through the MS documentation now to see about...