This is a tool that helps SQL Server data export from databases in various formats including plain text.
SqlToTxt is a tool to export SQL Server data to file in various forms such as csv, text, sql, xml, html, excel, etc. Data to be exported can be harvested from a specific table, the complete schema or from a SQL query. The tool supports export of text (ntext) and image fields. The export activities could be scheduled and automated through command line commands. That should relieve the IT department of quite a bit of work. Further time saving is achieved through ability to save session parameters. You could always reuse the saved data without the need for setting up the routine sessions again and again. For the data export activity, the tool is able to connect to a local server as well as a remote one, when required.
When you do need to set up a session (there’s always a first time things are done), the configuration is done easily through the visual interface. It takes only a few clicks to set up a session. You need to select the schema, the table and the fields as needed. Data delimiters, data type to which to be exported etc. are easily selected. You get a progress bar showing you how the transfer is going. The tool also collects log during the transfer process. It should be possible to find what were the reasons when there are problems. This is a neat and handy tool for data transfers when you need to do this often.