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

Comapre Tebles

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Comapre Tebles

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • October 22, 2010 at 5:54 pm #31448
      peterlaursen
      Participant

      Did you click the 'Compare Now' button after selecting the 2 databases (source and target)?  If  'Compare Now' does not generate a sync script the databases are identical.

    • October 24, 2010 at 3:57 pm #31449
      peterlaursen
      Participant

      My reply was not complete/correct.

      After 'Compare' you will have to select in the left pane (using the checkboxes) which objects need to be synced.  If you have 'hide identical' checked the pane will display empty.

    • October 25, 2010 at 11:51 am #31450
      nithin
      Member

      I will elaborate little if you still have the problem.

      Quote:
      All i see is just two tables after synchronization complete

      As I understood you have many tables in Source and Target and after you 'Compare' Schemasync tree-view shows only two tables. This is because schema sync identified all other table's schema is same for both source and target.

      If you like to see all tables including identical-schema tables, do the following:-

      i) Select both source & target databases

      ii) Un-check all the check-boxes in the right pane under section “Hide and Ignore Objects” (For you case you must un-check the option “Identical”)

      iii) Click on 'Compare button.

      Please see the screen-shot attached.

    • October 26, 2010 at 4:49 am #31451
      nithin
      Member

      The screen-shot attached.

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