Best method to copy a file to the SQL Server machine

sqlbulkcopy sqlclr sql-server

Question

A file transfer from the client computer to the server computer is something I'm researching. One route I considered was developing a CLR method that takes a stream as input. The BCP utility is another notion I've heard, but I haven't been able to discover any instances of it being used in practice.

Does passing a blob to BCP and importing it into a table work, or would there be more procedures necessary? Which approach would be the most effective for a file copy feature?

1
0
3/27/2013 7:05:19 PM

Accepted Answer

Blobs may be moved in and out of the database using BCP. A reference to scripts for importing and exporting files as blobs that start with may be useful was also noticed.

0
3/27/2013 7:53:15 PM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow