BCP data to/from SQL Server
BCP data from database to file
"c:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe" database_name..table_name out c:\data_file.csv -c -q -b 1024 -S server_name -U user_name -P password -e c:\\log_file.log
BCM data from file to database
"c:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe" database_name..table_name in c:\data_file.csv -c -q -b 1024 -S server_name -U user_name -P password -e c:\\log_file.log
Comments
Post a Comment