Just like the title says. All I need is the BCP program on my client computer. The BCP will be from a remote machine, so I don't want to install SQL Express or the management studio or any of that.
How can I do this?
Just like the title says. All I need is the BCP program on my client computer. The BCP will be from a remote machine, so I don't want to install SQL Express or the management studio or any of that.
How can I do this?
The only supported way is to install one of the SQL Server distribution packages (MSI). You are prevented by the terms of the license you agreed to to copy the bpc.exe file to another location (or, for the matter, any other file or 'crap' as you call them). If you don't like this situation, then feel free to build your own bulk utility executable and redistribute it as you like. The interface is called
IRowsetFastload
is is documented, good luck.