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

Structure Synchronization Tool

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Structure Synchronization Tool

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 23, 2004 at 9:59 pm #8584
      dany
      Member

      db1 has one table “table1”:

      id int

      car char

      name char

      db2 has one table “table1”:

      id int

      name char

      bike char

      If you use Structure Synchronization Tool to update (synchronize) db1 SQLyog 3.71 creates this:

      alter table `db1`.`table1`,

      drop column `car`,

      add column `bike` char(1) NULL after `car`;

      If you execute the query:

      Error Code : 1054

      Unknown column 'car' in 'table1'

      You cannot refer to the 'car' field that you've just dropped !!!

      Bye

    • October 1, 2004 at 12:21 pm #16320
      Ritesh
      Member

      Hello,

      Check out SQLyog 4.0 BETA 2.

      Apart from various bugfixes of BETA 1 (including the bug reported by you), it has got a new and improved SQL Editor. Now you can edit large SQL files without noticing any performance degradation.

      For more information visit: http://www.webyog.com/forums/index.php?act…st=0&#entry3674

      Eagerly waiting for your comments.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.