USE [IEOSMultiTenancy];  

GO   
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'ID_ma5367353631';
GO
CREATE CERTIFICATE IDSCANDBCERT
   WITH SUBJECT = 'IDSCANDBCERT';  
GO  
CREATE SYMMETRIC KEY IDSCANDBENCKEY  
    WITH ALGORITHM = AES_256  
    ENCRYPTION BY CERTIFICATE IDSCANDBCERT;  
GO  

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;