MyDAC

Integration with dbForge Studio for MySQL

Since version 7.5.10, MyDAC supports dbForge Studio for MySQL. dbForge Studio for MySQL is a powerful and comprehensive MySQL GUI tool that provides a complete set of instruments for server management and administration. This tutorial explains the integration between MyDAC and dbForge Studio for MySQL.

Compatibility

MyDAC supports dbForge Studio for MySQL in almost all Delphi and C++Builder versions except the following: Delphi 2006, Delphi 2006 .NET, C++Builder 2006, Delphi 2005.

Choosing Integration

It is possible to choose what tool will be used by MyDAC. Moreover, it is possible to disable integration with any tool whatsoever. This can be done in the Delphi main menu->MyDAC->Database Tools menu. There you can choose one of the three options (two options for IDE versions earlier than RAD Studio 2007):

Option Meaning
dbForge Studio for MySQL Integration All functionality described below uses dbForge Studio for MySQL
dbForge Fusion for MySQL Integration All functionality described below uses dbForge Fusion for MySQL
dbForge Fusion for MySQL does not support IDE versions earlier than RAD Studio 2007, therefore there is no such option in these IDEs.
No Integration All functionality described below is disabled and cannot be used

Using dbForge Studio for MySQL In Components

When dbForge Studio for MySQL integration is enabled, several MyDAC components obtain additional functionality.

TMyConnection

The TMyConnection component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the "Find in Database Explorer" submenu. Clicking this submenu will cause the following steps to be performed by MyDAC and dbForge Studio for MySQL:

Also, the TMyConnection editor form obtains a dropdown list that is filled with connections from Database Explorer of dbForge Studio for MySQL. When a value from this list is chosen, TMyConnection's options are filled with the options obtained from dbForge Studio for MySQL.

Note: The dropdown list on the TMyConnection editor form is filled only if dbForge Studio for MySQL was running before the editor was opened.

Note: Using any submenus of the "dbForge Studio for MySQL" popup menu described below opens dbForge Studio for MySQL (if it was not opened before).

TMyQuery

The TMyQuery component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the following submenus:

Also, opening the TMyQuery editor form opens dbForge Studio for MySQL (if it was not opened before). This allows using powerful SQL editor of dbForge Studio for MySQL directly in the IDE.

TMyTable

The TMyTable component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the following submenus:

TMyStoredProc

The TMyStoredProc component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the following submenus:

Also, opening the TMyStoredProc editor form opens dbForge Studio for MySQL (if it was not opened before). This allows using powerful SQL editor of dbForge Studio for MySQL directly in the IDE.

TMyCommand

The TMyCommand component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the following submenus:

Also, opening the TMyCommand editor form opens dbForge Studio for MySQL (if it was not opened before). This allows using powerful SQL editor of dbForge Studio for MySQL directly in the IDE.

TMyScript

The TMyScript component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the following submenus:

Also, opening the TMyScript editor form opens dbForge Studio for MySQL (if it was not opened before). This allows using powerful SQL editor of dbForge Studio for MySQL directly in the IDE.

TMyUpdateSQL

The TMyUpdateSQL component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL".
This menu contains the "Edit SQL" submenu, that contains the following submenus:

TMyEmbConnection

The TMyEmbConnection component obtains an additional popup menu (available by right-click on the component) named "dbForge Studio for MySQL". This menu contains the "Find in Database Explorer" submenu. Clicking this submenu will cause MyDAC to send the message to dbForge Studio for MySQL to find in its Database Explorer the connection with the same connection parameters as TMyEmbConnection has.

Note that if dbForge Studio for MySQL was not running until this moment, it starts running.

If dbForge Studio for MySQL found an appropriate connection in its Database Explorer, it will make this connection the current connection and open it. Otherwise, dbForge Studio for MySQL will show a window with the following content:
There is no suitable connection found in Database Explorer.
Do you want to create one.

It is up to you to decide whether you want or not to create a new connection in Database Explorer of dbForge Studio for MySQL.

Also, the TMyEmbConnection editor form obtains a dropdown list that is filled with connections from Database Explorer of dbForge Studio for MySQL. When a value from this list is chosen, TMyEmbConnection's options are filled with the options obtained from dbForge Studio for MySQL.

Note: The dropdown list on the TMyEmbConnection editor form is filled only if dbForge Studio for MySQL was running before the editor was opened.

© 1997-2017 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback