Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Ignoring Whitespace And Case In Schema Syncronization

forums › forums › SQLyog › Using SQLyog › Ignoring Whitespace And Case In Schema Syncronization

Tagged: ,

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • March 26, 2016 at 2:19 am #13520
      samnf
      Member

      Hi,

      I’ve been using SQLYog for 5 years, so I’m surprised I haven’t run into this yet. 

      I’m doing a schema sync between two databases (both MySQL 5.6) with SQLYog 12.13, and it’s flagging many ‘false’ differences in the stored procedures. 

       

      Looking a bit deeper, the only differences between most of them are whitespace and lower vs upper case (eg in words like VARCHAR) . 

       

      Is there a way to ignore whitespace and case for a schema sync? Or any ideas on other ways I could compare all the stored procedures to identify which have genuine differences vs whitespace? 

       

      Thanks!

      -Sam

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.