Tables With Index Differences Showing Up As Identical

MCTSQLMCTSQL Posts: 14 Bronze 3
edited June 13, 2007 11:55AM in SQL Compare Previous Versions
Only Option Set: Ignore White Space

Sample Scenario:
create database firstDB
go
use firstDB
go
create table t(a int, b int, c int)
go
create index x on t(a) include(b,c)
go
create database secondDB
go
use secondDB
go
create table t(a int, b int, c int)
go
create index x on t(a, b, c)
go
MCTSQL

Comments

  • Thanks for that - you're correct, SQL Compare doesn't register this difference. I've raised an issue in our bug tracking system for this. (Unless it turns out to be very trivial to fix, I doubt it will be fixed in the 6.0 release, as code freeze is very close now - but it will be considered for the point release.)
    Software Developer
    Redgate Software
Sign In or Register to comment.