An AG allows failing over multiple database at the same time for example if the are interdependencies.

Use SSIS. It will handle inserts in batches behind the scenes without having to roll your own solution. You can do it manually using ORDER BY with OFFSET.

I don't think SSIS is pausing just the refresh to the GUI is asynchronous. SSIS also commits periodically maybe that has something to do with it.

INSERT INTO Emptbl (
mp_Name
, Emp_Phone
, ...

I would use SSIS to load the data into your staging table. SSIS will handle chunking out the data so you don't have to move 1 million row in one...

What do you mean by against server b? A stored procedure can reference objects on a linked server. A stored procedure can be executed on a linked server if RPC...

Please post create table statement and inserts with sample data.

Use the COLUMNS_UPDATED() Function in your trigger and log that as well if you like.
Alternately a more elegant and simpler solution would be to duplicate SQL Server 2016's...

The port in a TNSNAMES.ORA listing is the port the Oracle Listener is listening on.

Mainstream Support for SQL Server 2008 R2 ended in 2014.