SET ReferenceType = N'Activity' WHERE ReferenceName <> N'BizTalkOrchestration' GO - Update ReferenceType to 'BizTalkService' ...

BizTalk Server 2010

              SET ReferenceType = N'Activity'    
              WHERE ReferenceName <> N'BizTalkOrchestration'
          GO

          -- Update ReferenceType to 'BizTalkService' when OtherActivityName is 'BizTalkOrchestration'
          -- Update ReferenceName to management server + management database + relationship
          DECLARE @ReferenceName NVARCHAR(4000)
          SELECT @ReferenceName = N'

SET ActivityID = @rootTrace WHERE ActivityID = @ContinuationToken - Move the data from the continuation to the parent row ... Set either ActivityViewRef or CubeRef or CubeRef and RtaRef for ViewAlert(ViewRef="{0}",ActivityViewRef="{1}",CubeRef="{2}",RtaRef"{3}"). ... SET ReferenceName = @ReferenceName WHERE ReferenceName = N'BizTalkOrchestration' GO - 6. Migrate completed relationship tables ... SET ReferenceName = @ReferenceName WHERE ReferenceName = N'BizTalkOrchestration' GO - 7. Migrate partitioned relationship ... SET ReferenceType = N'Activity' WHERE ReferenceName <> N'BizTalkOrchestration' GO - Update ReferenceType to 'BizTalkService' ... SET ReferenceType = N'Activity' WHERE ReferenceName <> N'BizTalkOrchestration' GO - Update ReferenceType to 'BizTalkService' ... Set this property to 'Yes' if this property field contains sensitive information that BizTalk Server should not track. The ... Set to Yes if FTP adapter must use SSL encryption while sending and receiving files to and from the FTPS Server. This setting ... Set to Yes if FTP adapter must use SSL while communicating with the server. Warning: Files are only encrypted over the network. ...