Questions tagged [bcp]
11 questions
2
votes
1 answer
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.
How can I do this?
Jasmine
- 145
- 1
- 6
2
votes
1 answer
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 contains one row which is also in the csv file (default…
Sam
- 909
- 4
- 15
- 26
1
vote
2 answers
Minimum install of SQL Server 2008 required to able to run bcp
I need to run bcp.exe on a client machine which has no SQL Server 2008 installed. Does anyone know the minimum install options I need to select to get the bcp tool? I tried 'Client Tools Connectivity' but that didn't include it.
Thanks, Jon
Jon
- 509
- 2
- 5
- 8
1
vote
2 answers
DR - Server 2003 Std SP2 Restore AD to different hardware
What I'm trying to accomplish might be the best way to start this.
I have to do a DR test. I'm given 2 days to rebuild AD, Fileserver and SQL from scratch from Dell/IBM hardware to HP Server DL380 Server.
What I started out doing was building a…
David Gargan
1
vote
1 answer
BCP/xp_cmdshell access denied - but only when running procedure from outside the server
I've been attempting to run some of my team's database deployment code to a SQL 2014 server on a Windows 7 test box. Part of this code is a procedure that pulls in data from a file using BCP from a file share on another server.
When I remote desktop…
Meric Stanley
- 11
- 2
1
vote
3 answers
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 will have on that.
Let me explain further; I…
Refracted Paladin
- 345
- 7
- 19
1
vote
1 answer
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 although I feel if I can present a safe security…
samaspin
- 111
- 2
1
vote
3 answers
What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?
As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create a new DB with the same schema, and reload all the…
Ernie Longmire
- 11
- 2
0
votes
1 answer
Disconnected primary replica set adding back into replica set
I'm looking for some advice on what to do with a primary replica set that gets disconnected from the network (e.g. data center network outage) to the extent that we promote one of the secondaries to primary to restore service for the application…
mattb
- 115
- 3
0
votes
1 answer
exporting with from MSSQL with BCP over Samba shared folder
I have a daily routine that runs over a SQL db and exports some data with BCP. I need to move these files to a Linux machine, so I shared the folder using Samba.
The local export works fine, yet when I try to export to the Linux directly it triggers…
Mike
- 113
- 1
- 1
- 7
0
votes
1 answer
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 files across the internet into the "intranet" of the…
ycseattle
- 165
- 1
- 2
- 5