I tested "/NC" option on 2 GB file with /NC setting  5,10,25,50,100,250

with  /NC 5,10,25  speed was about the same (between 3.00 and 3.6 MB/s)
with  /NC 50+     ...

Intermediate test result  
250 tables (160 GB)  ~ 800,000,000 rows 
Setting AutoAdjustBufferSize = True for all Data Flow tasks
Batch size custom ,based on size of table and data type 
Commit...

I used The AutoAdjustBufferSize Property based on article (https://www.mssqltips.com/sqlservertip/4221/improving-data-flow-performance-with-ssis-autoadjustbuffersize-property/)
my current "Engine Threads" set to 10 (for 5 tables), I will try to set  them to higher value 
What I...

Full scenario  🙂
production 
Server X (hosting db A  400 GB ) and Server Y (hosting db B 400 GB ) located 2000 miles from our office 
Project :  I...

it is non domain local server I don't want to go over security setting for importing ssis  and saving passwords to run as sql server agent jobs

goal is...

thanks a lot to  everyone for answers and clarification regarding pricing model and ideas to transfer reporting part to Azure data warehouse.

"Availability groups" functionality  integrated with managed instance, dba/user has no control over it. copies of database created for redundancy only.

I had conversation with MS support
based  of MS...

Hi Dino,
 thank you for valuable information. I really helps to reconsider approach to freelancing.

removed 'sa' from   "Publication Access List"   still see 'sa' in profiler

Stoped job 
 Name = MyServer-Pricingdb-12
 Owner = server_service
 Category = REPL-LogReader
 job step 1
   name = Log...

1. no, all  triggers defined without NOT FOR REPLICATION
I found workaround for my case 
As as said tables used by publisher in  db  serverB and ServerB_copy haves  different defintions
CREATE...

Thank for the tip, yes if you start pricing calculation from link https://azure.microsoft.com/en-us/pricing/dev-test/ you get DEV cost.

compare to prod cost 

found it 
https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/extract-a-script-from-a-trace-sql-server-profiler?view=sql-server-2017