how about this:
SELECT CAST(ABS(CAST(CAST(FirstDate AS DATETIME) AS INT) - CAST(CAST(SecondDate AS DATETIME) AS INT)) AS INT)/365
Not positive that outer cast to an INT is required, but...

I did this recently on our test box.  I just used the SQL 2016 installer to do this.  I clicked on the upgrade button and let it do its magic....

What is in the log AFTER the differential restore?

And what is your full restore command?  What about if you remove all of the optional arguments and just stick...

Is there a reason you want the databases on the cloud though?  Is this something customers are requesting or your company is thinking is a good idea?  I am just...

SSRS runs in separate memory space from the SQL Server Instance.  So if you have 24 GB allocated to SQL Server and 24 GB limit set to SSRS, it is...

Think I figured this one out on my own... the transaction logs were failing to make the report file; properties of the maintenance plan were pointing to the old backup...

That is strange... I know I've connected to SQL 2005 from a SQL 2016 SSMS version without any problems.  mind you that isn't for a data import/export.
I'd still recommend...

Possibly a dumb question, but are you sure you are putting it into the proper table on the destination side?  I think by default it dumps it into dbo.query.