SQL Compare Data 3.3 using old schema?

Brian Donahue

Hi Moran,

Does it help to click the 'refresh' button that's on the table selection
screen? This should pick up schema differences and add them to the
comparison session. It may only select the new columns if you had the
default settings of all tables and columns set, though...

Regards,

Brian Donahue
Red Gate Technical Support

"Moran Ben-David" <moran@rogers.com> wrote in message
news:iqkuuSV$DHA.1744@server53...
> Anyone had the problem where
>
> 1. you ran sql compare data agaist two databases, SourceDb and
> DestinationDb
> 1. you made changes to the SourceDb.TableA table through sql compare
> (added columns 2 columns)
> 2. you ran sql compare data again, but it didn't see the new columns?
>
> This is disconcerting as I was planning on buying this product as we are
in
> dire need of it.
>
> Is there some sort of Schema Snapshot that SQL Compare Data uses? Some
sort
> of cache that can be purged? I tried renaming the INI files in my
> ApplicationHistory folders to see if that would clear the cached schema
but
> it didn't.
>
> Why isn't it recognizing my new columns?
>
> Any help is greatly appreciated,
> Moran
>
>