how to use BCP in sql server through command prompt

Question

how to do bulk upload in sql server through command prompt .

Manish Kumar · Answer

Try this... BCP yourdbName.dbo.yourtablename in "C:\Testfile\Sample.txt" -c -T -b100000 -S SQL2012 (--sql2012 is the instance name)

Mani Kandan · Answer

Did you tried this: https://www.youtube.com/watch?v=SQC9CglDxAw https://www.youtube.com/watch?v=op_Hx4yelO4 https://www.youtube.com/watch?v=GWm9Ck_LB_I

Manish Kumar · Answer

Sorry did not understand .... What is main sql server and local (gussing sql server running on your machine as local)? Are you accessing sql server (assuming this a main server kind of live/prod) through your client instance.

Siva M · Answer

hi manish, But the file is in local system. i used my main sql server not my local .this suituation how can i do this .

Rajkiran Swain · Answer

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-and-export-bulk-data-by-using-the-bcp-utility-sql-server

Sundar · Answer

Follow this links, this may helps, 1) https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql 2) https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-and-export-bulk-data-by-using-the-bcp-utility-sql-server

how to use BCP in sql server through command prompt

Answers (6)