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 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. ... Set up has detected that following services are stopped on this machine. Please run these services before proceeding with ...