Import External Data
SQLyog provides Import External Data to streamline the transfer of data from any ODBC compliant data source to MySQL. To Import data from any ODBC compliant data source, select Powertools -> Import External Data or press Ctrl+Alt+O.
The import mechanism provides powerful and effective features, such as:
- Incremental import: Using special SQL statements and Triggers you can perform conditional data import. For example, you can run the import procedure daily and order it only to import data that appeared during the last day.
- Import sessions storage for future use: You can save your import session with all its settings and preferences and later use it repeatedly.
- Import sessions scheduling: You can order your import session to be scheduled, and SQLyog will automatically create a standard MS Windows scheduled task where you can specify your schedule preferences depending on your needs.
Import External Data requires an appropriate ODBC-driver (matching the data source) installed on the system where SQLyog is running. There are two ways how SQLyog can use such driver:
- by using a DSN setting. This option can be used for all ODBC data sources no matter if the data source is available on local or a remote system.
- or by specifying a data source file. In this case the ODBC driver details will be passed to the program transparently for user. This option can be used only if the data soruce is on local system and only for specific type of data sources. Currently supported files are: plain text files (.txt, .csv etc.) Microsoft Excel files (.xls) and Microsoft Access files (.mdb).
Note: This feature is available in SQLyog Enterprise and Ultimate.