Red Gate forums :: View topic - Compare encrypted functions doesn't work
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Compare encrypted functions doesn't work

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Francisco Lopez



Joined: 11 May 2010
Posts: 2

PostPosted: Tue May 11, 2010 10:27 am    Post subject: Compare encrypted functions doesn't work Reply with quote

Hi all,

I'm using SDK 8 for a internal tool to compare different version of our application.

So we have the following function to compare them

Code:
databaseA.Register(new ConnectionProperties(serverNameA, databaseNameA, userName, password), Options.Default);
databaseB.Register(new ConnectionProperties(serverNameB, databaseNameB), Options.Default);
Differences databaseAVsB = databaseA.CompareWith(databaseB, Options.Default | Options.DecryptPost2kEncryptedObjects | Options.IgnorePermissions | Options.IgnoreWhiteSpace | Options.IgnoreUsers);

HTMLReport.CreateHtmlReport(fileName, databaseA, databaseB, databaseAVsB , Options.Default, xslTemplate);


but the report doesn't show the differences, because it says that all encrypted functions are differente

Code:
-- Text was encrypted
GO

Sad

Someone can help me?

Regards.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Thu May 13, 2010 11:07 am    Post subject: Reply with quote

Thanks for your post.

Can you make sure you have redgate.backupreader.dll added as a resource to your project?

The backupreader is responsible for decrypting the encrypted objects as it works in a similar way to the way we read backup files.

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Francisco Lopez



Joined: 11 May 2010
Posts: 2

PostPosted: Fri May 14, 2010 10:51 am    Post subject: Reply with quote

Thanks for your replay.

I have inserted that DLL (redgare.backupreader.dll) and now show the following error message:

Can't load BackupReader.dll
Sad

I think is a license problem, so I've changed the file license.licx and I've inserted also SQLDataCompare libraries (but I don't need it, because I want to compare schemas)

But still show the same error.

I'll investigate why I have this problem, now I've removed the backup library to carry on with the development.

Regards
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri May 14, 2010 10:59 am    Post subject: Reply with quote

Thanks for your reply.

You shouldn't need to add the SQL Data Compare assemblies if you're only working with schema objects.

I would make sure you're using the correct version of the backup reader by referencing the backupreader.dll from the same folder as the SQLCompare.engine.

Also, backupreader.dll is 32bit only, so if your project is targeting x64, then this might be the problem.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
kevinlan



Joined: 02 Nov 2011
Posts: 9

PostPosted: Wed Nov 02, 2011 2:26 pm    Post subject: Index was outside the bounds of the array Reply with quote

i am so lost in this error message

when call the register function to Register the database, it raise this error all the same.if there hasn't Encrypted objects, it can work well.

Options myoptions = Options.Default | Options.DecryptPost2kEncryptedObjects | Options.IgnorePermissions | Options.IgnoreWhiteSpace | Options.IgnoreUsers;

productionDB.Register(targetConnectionProperties, myoptions);
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group