Tables that are the same show up as different in SQL Comp

• 
  Is it that the result grid shows differneces (the <=> arrows), or are the differences in the SQL view at the bottom of the screen?
  
  The side-by-side windows have some issues with reordered columns.

  Brian Donahue August 03, 2005 12:18

  - 0 +
• 
  The top window (the list of objects) indicates the tables are different with the red and blue arrows. The side-by-side windows at the bottom are identical. Each and every line on the bottom two windows have =. Nothing highlighted.
  
  About an hour ago, I noticed the same thing on a few stored procs, too.
  
  JD

  jdbruce August 03, 2005 18:46

  - 0 +
• 
  Hi JD,
  
  It sounds most likely that you want to use the 'ignore white space' option if you get differences in stored procedures.

  Brian Donahue August 04, 2005 13:52

  - 0 +
• 
  Well, yeah-- Ignore Whitespace has always been checked. I even tried turning it off. I was mistaken by the stored proceedures. It's only tables that are doing it. Not all of them, just a subset of them.
  
  JD

  jdbruce August 04, 2005 14:40

  - 0 +
• 
  Hello JD,
  
  Something else to be aware of -- SQL Compare's ignore white space option still doesn't ignore the commas in the table definition. This should hopefully be enhanced in the next major version, but for now, there is no way to ignore commas that are part of a column definition. For instance:
  
  CREATE TABLE MyTable (
  Identifier INT NULL,
  Data varchar(255)
  )
  
  is not the same as
  
  CREATE TABLE MyTable (
  Identifier INT NULL
  Data varchar(255)
  )

  Brian Donahue August 05, 2005 13:23

  - 0 +

Add comment

Please sign in to leave a comment.