Editor's review
CSV to MySQL is a tool to Convert, Migrate data to / from MySQL to CSV files or from CSV files to MySQL. You can convert multiple tables in one go from MySQL to CSV files / Delimited files or from CSV / Delimited files to MySQL database.
Features: CSV to MySQL is a two way tool that helps load CSV files to MySQL databases and converts MySQL data tables into CSV files. This way this software could be a useful tool for migrating data to/from other data sources. It is possible to do a mapping of source data columns to destination data columns. Rows can be filtered by the WHERE condition. While converting you can map source table columns to matching destination table columns. Filter rows by specifying WHERE conditions. You are able to save and restore sessions whenever similar data transfers must take place. Scheduling of sessions also is available. The built-in scheduler so that you can run transfer jobs at specified times/intervals. There is no need to write any code either to arrange these conversion. The interface is wizard based and takes you through the necessary steps automatically. The scheduler also helps execute sessions, sessions that are created with schedule date and time. CSV to MySQL Loader will automatically execute your session in the background. It will also save the actions and events in a log for later review. You can decide to transfer a single or multiple tables in a session, select/deselect columns while transferring. Destination data types and their length also can be modified. Provides a command line interface also to run migration jobs manually so that it can be easily integrated with your own application. It is supported on Win 2003,Win 2000, XP, Win ME,Win98 and Win95.
Overall: It is a nice and handy utility for data transfers to and from MySQL.
User comments