SPA-533 - How use decrypt option

Forum for users of SQL Packager database archive utility

SPA-533 - How use decrypt option

Postby nnodari » Tue Dec 08, 2009 1:56 pm


About new release (, the option to decrypt object doesnt work.

In final script of PACKAGE DATABASE: "Text was encrypted"
In final scruot of PACKAGE AN UPGRADE: " ---------- Schema SQL Warnings ----------
The procedure [legal].[lpr_sped_fiscal_bloco_c] cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized."

What I have to do to use this feature ?

Nilton Nodari
Posts: 19
Joined: Mon Mar 30, 2009 8:04 pm

Postby Chris Auckland » Wed Dec 09, 2009 8:15 pm

Did you use a sysadmin account to create the package?

Only sysadmin accounts will be able to decrypt the encrypted objects.

I hope this is helpful.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Postby nnodari » Thu Dec 10, 2009 3:20 pm

Great!!! Works fine.
Really appreciate!

Nilton Nodari
Posts: 19
Joined: Mon Mar 30, 2009 8:04 pm

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests