Compare encrypted functions doesn't work

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Compare encrypted functions doesn't work

Postby Francisco Lopez » Tue May 11, 2010 10:27 am

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: Select all
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: Select all
-- Text was encrypted
GO

:(

Someone can help me?

Regards.
Francisco Lopez
 
Posts: 2
Joined: Tue May 11, 2010 10:19 am

Postby Chris Auckland » Thu May 13, 2010 11:07 am

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

Postby Francisco Lopez » Fri May 14, 2010 10:51 am

Thanks for your replay.

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

Can't load BackupReader.dll
:(

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
Francisco Lopez
 
Posts: 2
Joined: Tue May 11, 2010 10:19 am

Postby Chris Auckland » Fri May 14, 2010 10:59 am

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

Index was outside the bounds of the array

Postby kevinlan » Wed Nov 02, 2011 2:26 pm

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);
kevinlan
 
Posts: 9
Joined: Wed Nov 02, 2011 2:13 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests