Microsoft SQL Server's bulk copy utility
2
votes
2answers
103 views
SQL Server BULK INSERT
I have a file saved using BCP and I want to know the specification of the table of the database that it needs to be materialized on the database. Is that possible?
Thanks
1
vote
0answers
465 views
Unable to open BCP host data-file error
Having problem using BCP via xp_cmdshell.
I exported the table data to a file as .dat but when I try to import the file to a new table, I am getting the below error. The SQL Server service and the ...
1
vote
0answers
99 views
SQL Server BCP imports, but table still has 0 records
I ran the following command from the command line on SQLServer 2008 R2
BCP C4L.dbo.districts in C:\TEMP\districts.sdf -f C:\TEMP\districts_import.fmt -T'
No errors were reported and it ran as ...
1
vote
1answer
174 views
Another BCP Export [Fail]ure
All, in SELECT Data Set Using Stored Procedure with BCP Error @Remus Rusanu provided a great solution to the problem. However, this evolved in to another problem: this BCP query now runs
DECLARE ...
1
vote
3answers
424 views
SELECT Data Set Using Stored Procedure with BCP Error
All, I have a BCP export query. It is failing with the useless error mesage on BCP usage:
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f ...
0
votes
2answers
327 views
xp_cmdshell bcp wont save file
EXEC xp_cmdshell 'bcp "SELECT lastconnectip FROM RF_USER.dbo.tbl_UserAccount" queryout "C:\test.txt" -T -c'
The command above runs, the output:
NULL
Starting copy...
1000 rows successfully ...
1
vote
2answers
494 views
Database table data transfer between different servers using bcp.exe and mysqldump
I have 2 servers, both are exact clones of another, one is PRODUCTION live use and the other is strictly for backend DATAENTRY.
Using MSSQL on two different servers I am using the following command ...
2
votes
1answer
394 views
BCP error near the keyword 'as'
I am new to using BCP but I am trying to extract data generated via a stored proc. This is a continuation of my original question which was a stored procedure with temp tables. This procedure has ...
3
votes
2answers
570 views
How to run bcp utility from root drive?
My machine does not have full SQL Server installed. The following distributable packages are installed on my machine:-
Microsoft® SQL Server® 2008 R2 Command Line Utilities
Microsoft® SQL Server® ...
5
votes
1answer
199 views
bcp database migration
I want one server to migrate the database to another server. On another server database already exists, then ist all the tables, but they are empty and I want to fill. For the filling, I want to use ...
4
votes
2answers
1k views
Minimum requirements to run Sql Server BCP.exe utility
I am working with a client who needs to do a data import to a remote SQL Server (2008) instance. The machine that the import will be done from cannot have SQL Server installed on it. Can the BCP.exe ...
8
votes
1answer
865 views
Optimising BCP performance for BLOB data
I'm the process of planning the live migration of a 2TB database to partitioned tables. The system is broadly speaking a document store, the majority of the space being allocated to LOBs of between ...
3
votes
2answers
1k views
How to import a varbinary(max) column with bulk import?
I have a varbinary(max) column that I need to bulk import. The data I'm putting into this column is a byte[] in C#. How do I format the data in the comma-delimited file used for bulk import? In ...
2
votes
1answer
1k views
bcp in of datetime type data results in an “Invalid date / time format”
I am familiarizing myself with the bcp utility, and I have a large table containing datetime data awhich I bcp out in several ways: native, character, delimited.
I then bcp in to a truncated table ...
5
votes
2answers
2k views
BULK INSERT - best usage
I need to export 150 million rows of only int/bigint columns from one SQL instance to another. I am using BCP queryout to export the rows and BULK INSERT to import the rows to another table.
I split ...
