Forum Discussion
Solved
How to decrypt a column in SQL Server that had been encrypted in C#
Hi all, I have a requirement to decrypt a column in SQL server. Someone else has encrypted the column in C# and used the RijndaelManged class to do this. Is there a way, to decrypt the column in SQL...
Seyed1 , you can try to find a way to implement the algorythm in plain T-SQL (I doubt it) or you use the SQL Server CLR integration with the RijndaelManaged Class.
See Overview of CLR Integration - SQL Server | Microsoft Learn
No matter which way you go, you have to implement it on your own.
Olaf
Seyed1 , you can try to find a way to implement the algorythm in plain T-SQL (I doubt it) or you use the SQL Server CLR integration with the RijndaelManaged Class.
See Overview of CLR Integration - SQL Server | Microsoft Learn
No matter which way you go, you have to implement it on your own.
Olaf
Hi Olaf,
Thank you for taking time to answer my post. It seems that the best thing to do is to decrypt the colmn using C#.NET instead of SQL Server. I don't know if a column that is encrypted in C# could be decrypted in SQL Server. I created a C#.NET Windows Form and was able to read a csv file and write the same columns to another csv file. In between the reads, I will call the method for decrypting the column. The only thing that I need is to get the password used for encrypting the column and I think, this column will be decrypted.
Thanks again,
Seyed
Thank you for taking time to answer my post. It seems that the best thing to do is to decrypt the colmn using C#.NET instead of SQL Server. I don't know if a column that is encrypted in C# could be decrypted in SQL Server. I created a C#.NET Windows Form and was able to read a csv file and write the same columns to another csv file. In between the reads, I will call the method for decrypting the column. The only thing that I need is to get the password used for encrypting the column and I think, this column will be decrypted.
Thanks again,
Seyed