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...

Really vague so hard to tell what the issue really is.
No need to change to SSIS - but you may need to change your process a bit depending on...