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

How To Copy Just Column In Synchronization

forums forums SQLyog Using SQLyog How To Copy Just Column In Synchronization

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #12656
      dbusr
      Participant

      I'm trying to merge columns that one database has into a different database but it seems the synchronization tool is providing too much help. For example, given



      table A {

      a int 4

      b int 4

      c int 4

      }

      and



      table B {

      a int 3

      c int 3

      }

      I want to end up with



      table B {

      a int 3

      b int 4

      c int 3

      }

      When I run the tool, it has the ADD COLUMN b command but also the CHANGE col a and CHANGE col c command. I just want columns in table A that are not in table B to be copied. All others should be left alone. I have all of the hide check boxes checked except for the “To be created in Target.” Can someone please explain my mistake?

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