Transfer Data From Mssql To Mysql. In this step we need to provide the information about the source database in this case sql server. Click either the file data source or machine data source tab and then double click the connectorodbc dsn to which you want to export your table.
Perhaps the simplest would be to use mysqldump to dump the raw sql from your mysql database into a text file and then use the sqlite3exec function to execute that sql in order to populate the sqlite database. Double click in the adonet destination task and in the connection manager press new. Our companys portal website uses a mysql database that holds other project information location start date billing agent.
In this step we need to provide the information about the source database in this case sql server.
In this step you are writing the query to access to mysql table created at the beginning. Ask question asked 3 years 7 months ago. Check for prerequisites mysql must be installed on the system with default configuration. It lists the defined data sources for any odbc drivers installed on your computer.