DBScripter

DBScripter is an ODBC utility that creates an SQL script from any database accessible from your system. The script created can contain structure, indexes, and/or data statements to fully or partially replicate a database. The script is also fully configurable to meet all different DBMS requirements, such as special wording, formatting, and even special behavior of the SQL tool thats to be used to run the script. Configurations can be saved to allow for easy reuse. DBScripter comes with preconfigured profiles for the most common databases. This updated version features automatic detection of multi-user databases, support for RTF files, and more.

Version 5 now allows you to switch users/schemas/catalogs, it also is able to generate insert statements from free form sql, it can output the data in CSV format, it also includes a SQL Library for easy access to regularly used sql statements. In this version, you can now add where clauses to filter the retrieval of the data.