Gsqlcmd

gsqlcmd is a command line utility that allows: - executing SQL commands and scripts; - exporting database data to text and CSV; - exporting database data to HTML using templates; - configuring CSV import including creating target tables; - generating INSERT and UPDATE statements for importing CSV. gsqlcmd has a lot of options to tune results. You may easily do the most of your development, testing or ETL jobs. gsqlcmd supports: Microsoft SQL Server, SQL Server Compact, Oracle Database, IBM DB2, MySQL, NuoDB. You may work with supported databases in the same manner.

Requirements:

SQL Server 2005, SQL CE 3.5, Oracle Database 10G R1, IBM DB2 9.5, MySQL 5.0, MariaDB 5.1, NuoDB 2.0.