Page 1 of 1

SQL decryptor error

Posted: Tue 25 May 2021 11:45
by oaktree
I have more than a hundred encrypted procedures and functions that I want to decrypt. I tried using dbforge sql decryptor decryption wizard for in place alter but I get the error:

Definition is invalid. Can't find CREATE keyword.

When I try to see the DDL script of a stored procedure, I get the error:

A definition for the object dbo.pt_blocks cannot be shown because it is encrypted by a third party tool

How do I solve this and decrypt all objects?

Re: SQL decryptor error

Posted: Fri 28 May 2021 06:36
by alexa
We will investigate this issue when developing the next product versions.

Re: SQL decryptor error

Posted: Wed 21 Jul 2021 18:04
by alexa
We would need you to provide us a backup of the database to investigate this further.