SPA-533 - How use decrypt option

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

SPA-533 - How use decrypt option

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

Hi,

About new release (6.3.1.7), 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 ?

regards
Nilton Nodari
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby Chris Auckland » Wed Dec 09, 2009 9: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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

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

Great!!! Works fine.
Really appreciate!

Att,
Nilton Nodari
Att
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests