Create an Empty Database Using SQL Server Integration Services

  • Comments posted to this topic are about the item Create an Empty Database Using SQL Server Integration Services

  • Hi Nisarg and anyone else interested.  I tried this and it creates a nice empty database.  Thanks for the instructions.  But I still find a big problem with it that revolves around encryption/decryption.  I find that I can't use the decryption procedures on this database despite recreating the master key, certificate, and symmetric keys.  They only work if I restore the original whole database.  I can restore it with a different name or whatever but decrypting works fine from the restored database but not the new empty copy created.  Any ideas regarding how to get a call like the following to work on the empty database.

    OPEN SYMMETRIC KEY FsaKey DECRYPTION BY CERTIFICATE FsaCert;

    SET @clearText = DecryptByKey(@cipherText);

    SELECT @clearText OUTPUT;

    CLOSE SYMMETRIC KEY FsaKey;

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply