After your import session has finished, you can check if it was successful or not. First, you can look at the sja.log file which is located in the SQLyog root folder. If…
After you have specified all settings and preferences for your import job at the previous tabs of the Import External Data Wizard, you should indicate what you would like to…
At this page you can define what SQLyog should do if an error occurs during your import session. The options are: Email Options This page appears if at the previous…
Quite often you may face the necessity to repeatedly import data from the same external ODBC source to your MySQL database. Besides, usually you are most likely interested to get…
The button WHERE opens the SQL WHERE Dialog: By specifying a WHERE clause in this dialog you tell SQLyog to import only rows that satisfy the criteria set by you. Please note that…
At the tab Trigger Options of the Advanced Options Dialog you can setup and use the unique feature of Triggers on import source. The essence of Triggers is that they allow you to introduce changes…
The button Advanced opens the Advanced Options Dialog. In the dialog tab DDL/DML Options you can tell SQLyog how to behave if it finds resembling data at your MySQL destination. SQLyog’s import external data provides…
The button Map opens the Column Mappings and Transformations Dialog as shown in below: By default SQLyog will map all the columns from the source table. If you do not want to import a…
Here you will see the list of tables available for import. To select the tables you want to be imported, check boxes next to their names. Please note the following:…
