This is a simple program that fulfils specific requirements
- You need a CSV created from a SQL query
Very simple to use. Just start it up and enter in the connection string, query and the output file name for the CSV.
- CSV Helper - An awesome CSV handling library
The issue is the delimitation. If a data cell contains a comma and line break, then the export tool kind of ignores it by default.
There is a setting inside of SSMS that supposedly fixes this, but it still has issues. The line breaks can still leave broken unusable CSV records.
- Command line version
- Support MySQL and other abitrary SQL solutions
- Save state / Remember settings
- v1 - Initial release with basic functionality of querying against a database, which is saved to a file. Simples.