Without knowing db sizes, usage and load on the current server as well as what their customers do with the server its hard to tell you which is better.

Not really aware of it but maybe related to the fact that the latest version for 2015 had issues deploying to SSIS catalog, mainly when deploying single packages.

in...

Didn't mention this one as this is...

get sp_whoisactive and run it while the lock is happening
http://whoisactive.com/downloads/

best to do it when you manually run the proc manually as at the point you know...

Don't use SSIS for that as it sucks with LOB types.

Powershell or C#  (can be inside a SSIS package script task if you prefer) with a sql reader...

no ties - within each sqn the ldts are unique

did you find out your self or did you find something on the net? 

We have a similar problem on our shop at the moment.

Thanks

As mentioned before Microsoft or vendor should always be consulted.

But on this case the licensing documents are pretty clear.
From the Licensing Guide on the link above

try expanding the connections tab on the left - the DBA ones would normally be on the bottom of it

Just in case - prior to a particular version of CRM (2013 or 2015 I think) all foreign keys were defined as not for replication and were would not be...

While advice is still to contact Microsoft I am sharing an email I exchanged with them (licensing team) last year.

For SQL Server Dev edition and because it is...

Move empty file will move data blocks as they are onto a new file - the main mdf file will still remain as is with system objects - the shrink...

As this is a once off task the "recomendation" not to shrink the files does not apply.
And as this is to go to a new database I assume that...

Why not do the whole merge, sort and exception handling on the database itself?
even if the 2 tables are in 2 different SQL Instances in many cases it will...