usage: freebcp [[database_name.]owner.]table_name|query {in | out | queryout } 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] [-D database]
[-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
Options (26)
| Option | Description | Source |
|---|
-A packet_size | Set the size of a TDS packet to packet_size. | man |
-D dbname | The name of the default database to use. | man |
-E | Write the data in datafile to the table's IDENTITY column. | man |
-F firstrow | The first row to copy from the input file or database table. | man |
-I interfaces | The name and location of the interfaces file to search when connecting to servername. | man |
-L lastrow | The last row to copy from an input file or database table. | man |
-O options | SQL text to set connection options prior to the bcp operation. | man |
-P password | The password associated with username. | man |
-S servername | The name of the Database Server to which to connect. | man |
-T textsize | For text or image columns, set the maximum number of characters to request from the server. | man |
-U username | A database login name. | man |
-b batchsize | The number of rows per batch of data copied. | man |
-c | The host data file is (or will be) in "character" format, i.e., a text file. | man |
-d | Turn off any logging. | man |
-e errfile | Write errors to errfile. | man |
-f formatfile | The format of the host data file is described by formatfile. | man |
-h hints | Set bcp hints. | man |
-m maxerror | Stop after encountering maxerror errors. | man |
-n | The host data file is in “native” format. | man |
-r row_term | The row terminator for a character file. | man |
-t field_term | The field terminator for character file. | man |
-v | | man |
-V | Print the version information and exit. | man |
-i inputfile | Read input data from file specified. | man |
-o outputfile | Write output data to file specified. | man |
-C charset | Specify character set to use to talk to server. | man |
Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.