linkedserver and MSDTC

env: Windows server 2012R2
        SQL Server 2008R2

這次嘗試施做Linkedserver與MSDTC

首先我們先準備2台server，本次沒有加入網域
1.WIN-QH8BBS4P9J9
2.WIN-TKJM6HAMBVJ

1.在WIN-TKJM6HAMBVJ建立Linkedserver到WIN-QH8BBS4P9J9

2.利用powershell啟用MSDTC
Add-WindowsFeature Application-Server, NET-Framework-45-Core,

AS-WS-Atomic, AS-Outgoing-Trans, AS-Incoming-Trans 

3.設定MSDTC內容

4.透過Linkedserver與MSDTC複製資料到本地端SQL Server

begin distributed transaction 

insert into [WIN-QH8BBS4P9J9].test.dbo.tb1

select * from [WIN-TKJM6HAMBVJ].test.dbo.tb1

delete from test.dbo.tb1

commit transaction