1
Vote

Error while comparing SP

description

Got the below error. We have some Stored procedures encrypted - this could be the reason.

Is it possible to have an option to ignore encrypted objects and proceed?

Thanks
Mahesh



Open DBDiff Beta 0.8.9.61
Error Generating Synchronized Script
NullReferenceException: Object reference not set to an instance of an object.
at DBDiff.Schema.SQLServer.Generates.Model.Index.ToSqlDiff() in DBDiff.Schema.SQLServer2005\Model\Index.cs:line 271
at DBDiff.Schema.Model.SchemaList2.<>c__DisplayClass9.<ToSqlDiff>b__6(T item) in DBDiff.Schema\Model\SchemaList.cs:line 131
at DBDiff.Schema.Model.SchemaList
2.ToSqlDiff(List1 schemas) in DBDiff.Schema\Model\SchemaList.cs:line 131
at DBDiff.Schema.Model.SchemaList
2.ToSqlDiff() in DBDiff.Schema\Model\SchemaList.cs:line 126
at DBDiff.Schema.SQLServer.Generates.Model.Table.ToSqlDiff() in DBDiff.Schema.SQLServer2005\Model\Table.cs:line 371
at DBDiff.Schema.Model.SchemaList2.<>c__DisplayClass9.<ToSqlDiff>b__6(T item) in DBDiff.Schema\Model\SchemaList.cs:line 131
at DBDiff.Schema.Model.SchemaList
2.ToSqlDiff(List1 schemas) in DBDiff.Schema\Model\SchemaList.cs:line 131
at DBDiff.Schema.SQLServer.Generates.Model.Database.ToSqlDiff(List
1 schemas) in DBDiff.Schema.SQLServer2005\Model\Database.cs:line 249
at DBDiff.Front.Form1.ProcesarSQL2005() in DBDiff\Front\PrincipalForm.cs:line 125

5A18B1E70A82B51A686DDD8B6D7A0404

comments

jspraul wrote Jun 17, 2013 at 4:21 PM

Hello Mahesh, thanks for taking the time to submit this issue, along with a possible cause. My apologies for the delay in responding... I will take a look at this the next time I get a chance to dig into the code.