USE [IEOSMultiTenancy];  
 
GO  
OPEN SYMMETRIC KEY IDSCANDBENCKEY  
   DECRYPTION BY CERTIFICATE IDSCANDBCERT;  
GO

GO  
UPDATE dbo.MultiTenancyMapping
SET ConnectionString = EncryptByKey(Key_GUID('IDSCANDBENCKEY'), ConnectionString);  
GO
CLOSE SYMMETRIC KEY IDSCANDBENCKEY;