New answers tagged mysql-workbench
I would prefer SQLyog for this. SQLyog provides Import External Data to streamline the transfer of data from any ODBC compliant data source to MySQL. It requires an appropriate ODBC-driver (matching the data source) installed on the system where SQLyog is running.
You have many state changes you want to happen in order for your interaction to be considered a success. This pretty much defines the "atomic" goal of a transactions. begin; --start the transaction insert into person values (...); insert into address values (....); commit; --finish the transaction This ensures that if there was an error any where along ...
I recommend to do this migration in two steps. Use MySQL Workbench to migrate most of the db objects and data to MySQL (table data will be copied by this process too). See Using the MySQL Workbench Migration Wizard for details. This will leave you with manual work for specific objects like stored procedures. No tool can do an automatic migration as stored ...
Top 50 recent answers are included