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

Syncronize 2 Databases – Strucrture And Data

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Syncronize 2 Databases – Strucrture And Data

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • October 10, 2007 at 10:58 am #25105
      peterlaursen
      Participant

      With SQLyog you will have to execute

      * structure sync

      * data sync

      in that order

      “I don't want to run all the updates one by one.

      I saw there are 2 tools in the SQLYog – structure compare and DB sync which may do the job but in many steps”

      >> no in TWO steps – not MANY steps

      I want to create a diff script automatically that will upgrade the production schema.

      >> structure sync will 'generate a script', data sync will not 'generate a script'. data sync if implemented in the SJA, that is a compiled binary. BINARY .. not SCRIPT.

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