ORATEA

freetds中使用freebcp导数据

freetds中使用freebcp导数据

freebcp是freetds中提供的功能和bcp类似的数据导出导入工具

[oracle@dw_testdb sql_server]$ freebcp
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]
       
example: freebcp testdb.dbo.inserttest in inserttest.txt -S mssql -U guest -P password -c

我现在主要是从SQL SERVER中把数据导成文本。

常用方式：

1，按表导出

freebcp sunwg out sunwg.txt -S robit -U robit -P smallrobit -c

2，按查询导出

freebcp “select * from sunwg” queryout sunwg.txt -S robit -U robit -P smallrobit -c

通过freebcp更加方便灵活，比原来采用的oracle透明网关更加实用。