Sample App Problem - CreateFromIntersection Returns Nothing

Brian Donahue

Hi Tim,

Please check your version of RedGate.SQLDataCompare.Engine.dll. I
believe this was a problem in early version 3 of the library that was fixed
somewhere along the line. The current version of the file is 3.37.

You can get this by running Data Compare and doing 'check for updates'
from the Help menu. If you can't run Data Compare because you don't have a
licence for it, please email me directly and I will send the download
instructions.


Regards,

Brian Donahue
Red Gate Technical Support

"Tim Duval" <tduval@firstam.com> wrote in message
news:Ne4RKndZEHA.2428@server53...
> Hi..
> I'm using a registered copy of the SQLToolkit. I'm trying to run the
sample
> app code to compare two identical databases (made a copy of one before I
ran
> it).
>
> Here's the vb.net sample line of code that prevents the comparison from
> happening:
>
> Dim commonTables As Tables = Tables.CreateFromIntersection(db1.Tables,
> db2.Tables)
>
> I checked the count/contents of db1.tables and db2.tables through debug
and
> the collection is populated. However, the line of code above returns
nothing
> to the collection commonTables. The following code that does the
comparison
> doesn't work.
>
> I then tried compiling the sample code for the command line utility and
ran
> it.
> It produced the following error:
>
> Getting database 1 (local).db1
> Getting database 2 (local).db2
> Comparing databases
> FAILED TO COMPARE DATABASES
> ExecuteReader: CommandText property has not been initialized
>
> I double checked the tables to make sure that primary keys existed and
they
> are present. Any ideas on what could be going wrong?
>
>
> Thanks
>
> Tim Duval
> tduval@firstam.com
> 619-938-6706
>
>