On openSuSE 13.2
sudo zypper install freetds-tools
Ubuntu 14.04
sudo apt-get install freetds-bin
aklaver@killi:~> freebcp -h
usage: freebcp [[database_name.]owner.]table_name {in | out} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n] [-c] [-t field_terminator] [-r row_terminator]
[-U username] [-P password] [-I interfaces_file] [-S server]
[-v] [-d] [-h "hint [,...]" [-O "set connection_option on|off, ...]"
[-A packet size] [-T text or image size] [-E]
[-i input_file] [-o output_file]
example: freebcp testdb.dbo.inserttest in inserttest.txt -S mssql -U guest -P password -c
From what I can make out this tool reads the BCP files and puts them into an SQL server. I need to either put them into a postgres server or to output as plain text CSV files.
