Conglomo Data Pump

An application for extracting data from a database using a SQL query, and writing that query to a spreadsheet file.

This program can be used in batch files to automate data export from your database, or to extract data from a one off query.

Supported databases

Firebird
Microsoft SQL Server
MySQL

Supported output files

CSV
Excel 97-2003
Excel 2007+

Usage

DATAPUMP.EXE [database type] [file type] [connection string] [sql file] [output file]

Notes

The database and file type parameters usually do not need to be entered
The SQL file should end in .sql
The SQL file should contain only one SELECT statement, and no other queries or commands
The output file should end in the correct file extension (.csv, .xls, .xlsx)
If the connection string contains a clear identifier to the datbase file type (i.e. .fdb, .gdb, .mdf), you may not need to specify the database type
Parameters can be entered in any order, so long as they are correctly formed
The error code 0 will be emitted on success, 1 on an error

Examples

DATAPUMP "User=SYSDBA;Password=masterkey;Database=C:\db\mydb.gdb;DataSource=localhost;" "c:\data\get all companies.sql" companies.xlsx

DATAPUMP Firebird CSV "User=SYSDBA;Password=masterkey;Database=C:\db\mydb.gdb;DataSource=localhost;" c:\data\getcompanies.sql "c:\data\my companies.csv"

DATAPUMP MySQL XLSX "Server=localhost;Database=reports;User=root;Password=;" c:\data\names.sql c:\data\names.xlsx

DATAPUMP MSSQL XLS "Data Source=localhost;Initial Catalog=reports;User Id=sa;Password=;" c:\data\names.sql c:\data\names.xls

DATAPUMP "Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=C:\db\website.mdf;Integrated Security=SSPI;MultipleActiveResultSets=true;AttachDBFilename=C:\db\website.mdf" c:\data\names.sql c:\data\names.xlsx