Need to get a better feel for unique column additions/change

• 
  Hello,
  
  Thanks for your post. You may want to look at the SQL Compare's project options. There is an option that affects whether or not column order is considered as a difference. It's the 'force column order' option.

  Brian Donahue January 14, 2007 17:42

  - 0 +
• 
  This option seems to be a synchronization option and not a compare option. Basically, when table XYZ comes to me, it might look like
  
  field1 char(10)
  field3 char(20)
  field2 char(20)
  
  and my baseline table might be
  
  field1 char(10)
  field2 char(20)
  field3 char(20)
  
  I've had issues where the compare lists some field comparisons on the first table as 'X' only to have the same field located 30 fields later in the second table.
  
  What I'm looking for is a Comparison option like "Show columns in alphabetical order" and perform the DIFF after the sort.
  
  My brute force solution is to get them into Excel and sort the columns and then manually DIFF them. Obviously, not a great time investment.

  dahannajr January 18, 2007 19:30

  - 0 +
• 
  Is this about the side-by-side text windows? They're not 100% accurate. The option to force the column order (to be identical) affects both the comparison and synchronization process.

  Brian Donahue January 19, 2007 06:54

  - 0 +
• 
  It is largely about the side-by-side columns being accurate. I have no problem with the synchronization part. That has always wored well for us. What I'm trying to control is change management. I need to see if there have been any changes made to the data structure when I get a new version of this FoxPro data file which has been converted to SQL. The fields are many times not in the same order and I want to rely on the side-by-side view to give me an accurate reflection on how "in-sync" the two models are.

  dahannajr January 22, 2007 18:26

  - 0 +

Add comment

Please sign in to leave a comment.