1
vote
1answer
126 views

How do I configure a stored procedure wrapper and security settings to provide safe access to command-line operations?

I'm ultimately trying to find a way to allow the safe use of BCP and selected other command-line functionality from within SQL Server. The organisation I am in currently have xp_cmdshell disabled ...
2
votes
1answer
590 views

How do I install ONLY the bcp program for SQL Server

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. ...
0
votes
1answer
245 views

SQL Server BCP performance: over the wire, or copy to intranet first

We need to use the BCP utility to port database (>1GB) to a remote database server across the internet. We can use the BCP utility to connect to the remote SQL Server, or we can copy over the BCP ...
0
votes
1answer
1k views

bcp import file how to ignore duplicates?

I want to import a csv file into a sql server 2008 R2 database table using bcp using a command like this: bcp Database..TableName in TableName.csv -n -T -E -S localhost My problem: the table ...
1
vote
3answers
2k views

SQL INSERT INTO vs SELECT INTO vs BCP in a Replication Topology(Stage Environment)

I would like to add the information from my Production DB to my Stage DB. I have a BAK of the Production DB and could just restore from that on Stage but I am concerned of the impact Merge Replication ...