In real life, I've created views from stored procedures with no problems at all using dynamic SQL.  There were two reasons to do so... "Pass through" views to support "Swap'n'Drop"...

I don't believe it actually hit the streets.  I think it was only in preview version.

Our database is a pretty complicated enterpirse database which has many tables. we do want data to make sense, and this is for our training enviroment, it has to...

I haven't tried it but, perhaps, Detaching/Attaching.  I think that Offline/Online would still keep the same value.

Heh... speaking of "better" for DevOps, I tried to rate the post and I'm logged in and yet it still says that I have to login to rate it and...

Ok... no response from the WebMaster on this issue.  @steve-2 Jones... any help here?

Heh... probably not because you're probably not being notified of this post, either. 🙁

I've not delved into DBATools.io much.  Which...

I'm a bit confused.  Can you post the actual value of what FileSize is BEFORE your modifications, please?  Also, what are you using as a reporting tool?

I'm bumping this for you, Karen.  Seems like it should be simple to do in SSIS but I don't use SSIS and can't help.

If you're using SomeDateCol BETWEEN FirstOfMonth and EOMonth, then you have closed/closed and it's not bullet proof because SomeDateCol could have a time in it.

Using the basic criteria of SomeDateCol...

BULK INSERT may be your friend here.

So... how'd it go?

1. Do you have any PII or other sensitive information on the original databases that you've backed up?
2. What are you using to do the original backups?
3. Does the server...

Awesome!  Yeah, that previous state an time made life a whole lot easier!  Nicely done on the research.

So, enquiring minds want to know... Is it done yet? 😀