Yes still supported in 2017 and 2016 are temporal table and yes they need extra columns adding, going around changing existing tables to become temporal tables shouldn't be that much...

It's been said already but I will say it again - With something as legally binding as licensing, don't trust public forum as the truth, speak to Microsoft, speak to...

Since you posted in the SQL 2019 forum, I would say look at using temporal tables.  What your after sounds a lot like CDC but switching that on along with...

Why don’t you use something like log shipping and when it comes to cut over time backup the log with no recovery and replay the last log manually on the...

Something doesn't seem right then as they should route correctly if they are all different.

I don't like dynamic ports for instances, its a networking headache, I would set them all...

That is a new issue which should be in its own topic.

But as you have said yourself, you cannot install Polybase into a FCI.

To have multiple Polybase instances you must...

DBCC CLONEDATABASE is not multi server, it copies it to the same server so won’t meet your requirements.

Automate a backup restore operation using the traditional backup routines or use bacpac...

Yes so in each listener set the port to be different to the others

Listener1 port 1433

Listener2 port 1435

Listener3 port 1436

Etc

if all the listeners are set to 1433 that’s the issue...

Why does it need to be a while loop?

SQL is a set based language and should be used as such.  Row by row processing is slow hence the name ‘row...

That is where the configuration of the listener, ports, instances, replicas all comes in and should be static.

For the default instances, use port 1433 on the instance and the listener

For...

I can't see your setup, so I can't say for certain, but with multiple instances, your best creating a listener per instance&replica&database set

Eg Server1&Server2 on default instance is one listener ...

Confused as to why a while loop, this is achievable in a set operation

Get the list of books which have at least one populated status, then use that to pull...

Merge Join is the way to do any sort of INNER/LEFT/RIGHT/FULL join in SSIS, the below should give you an idea how to do it in SSIS

https://www.tutorialgateway.org/left-outer-join-in-ssis/#:~:text=SSIS%20Left%20Outer%20Join%20using%20Merge%20Join%20Transformation,Join%20in%20SSIS%20Using%20Merge%20Join%20Transformation%20.

I do have to...

State1 doesnt give anything more to the problem, thats just the generic something went wrong state no detail.

Do you have multiple instances on this setup?  Clutching at straws but I...

Have you copied the sql based logins to all replicas and ensured they have the same SID etc using something like sp_help_revlogin or DBATools powershell module?

Can you post the fill...