SQL Diff

[Ruslan Zasukhin]

On 11/8/14, 3:18 AM, "Mike Kerner" <MikeKerner at roadrunner.com> wrote:

Hi Mike,

Can you specify yet with which db you are working in Vstudio?

> It seems that in 5.6, the SQL Diff function doesn't capture everything that
> changes, even though all the properties are selected.
> 
> For instance, I just wanted to switch everything in a DB to not be case
> sensitive, so I changed all the Collates to nocase.  Then I ran an SQL Diff on
> the new version vs. the old version and none of the collates showed.
> 
> When I changed a collate on an index, that showed, but not on a column.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]