I am using sql server 2000. In one of my tables on the webserver database, we store confidential information. The asp.net application encrypts the information before storing it, using the build in .NET cryptography.RSA class.
Now I want to import order data into our internal database, and here I want to have the encrypted fields decrypted. Currently, we import by creating a csv-file via a webfrontend on the webserver, and the asp code generating the .csv decrypts the encrypted fields. The file is ftp-ed and imported into our intnernal DB.
Works fine, but we want to skip the steps of manually creating the .csv file, ftp-ing it and importing it.
I thought of setting up a linked server to our webdatabase and using directly inserting the new rows into our internal database using sql statements. But I dont know how to decrypt the encrypted fields in this solution.
* Is there a way to decrypt from T-SQL (for RSA encrypted data)?
* Or is there a complely different road to automatically import new rows without any manual steps, but with decrypting the encrypted fields?