Refresh from database (MySQLToSQL)

The Refresh from Database dialog box lets you select which objects to refresh from the MySQL database. Rows in the dialog box are color coded based on the state of the metadata:

  • If the object metadata has changed locally and in the MySQL database, the row is blue.

  • If the object metadata has changed in the MySQL database but not in SSMA, the row is yellow.

  • If the object metadata has changed locally, but not in the MySQL database, the row is green.

  • If the object is new in the MySQL database, the row is pink.

You can specify default object refresh settings in the Project Settings dialog box. For more information, see Project Settings (Synchronization) (MySQLToSQL)

To access the Refresh from Database dialog box, right-click an object in MySQL Metadata Explorer and click Refresh from Database.

Options

Term Definition
Collapse (-) Collapse all object groups to hide individual objects.
Expand (+) Expand all object groups to show individual objects.
Hide/Show Equal Objects Hides objects from the list if the object metadata is the same in the MySQL database and in SSMA.
Refresh from Database (arrow button) Use the arrow button to specify that the metadata for the selected objects should be updated in SSMA.
Do Not Refresh from Database (X button) Use the X button to specify that the metadata for the selected objects should not be updated in SSMA.
Legend Displays a Legend dialog box. The legend contains the mapping between row colors and metadata states.

To keep the Legend dialog box on top of the Refresh from Database dialog box, select the Show on top check box.