bcp
BCP task hangs while executing
We have a HPC node that runs some of our tasks in it. I have a task in my .net project that kicks the bcp utility on the HPC node and the output of the query that I have runs into 9 Mb.[详细]
2022-12-31 20:22 分类:问答What is the quickest way to import 60m records into SQL
I have a 5-6 tables in my database that I need to populate with test data to test peroformance in my app.[详细]
2022-12-31 06:59 分类:问答Bulk Copy from one server to another
I\'ve one situation where I need to copy part of the data from one server to another. The table schema are exactly same. I need to move partial data from the source, which may or may not be available[详细]
2022-12-26 03:32 分类:问答How to write an error message from an BCP operation to a log file and stop processing the batch file.
I have a BCP o开发者_运维问答peration in a batch command file. When there is an error in the BCP Operation I need to stop the processing and write the err msg in the log file[详细]
2022-12-25 02:54 分类:问答Run a shell command with arguments from powershell script
I need to extract and save a some tables from a remote SQL database using bcp. I would like to write a powershell script to invoke bcp for each table and save the data. So far I have this script that[详细]
2022-12-23 06:11 分类:问答incoherence in bcp command execution
I execute a bcp command in 2 computer. The first computer has windows xp and second 开发者_运维百科one has windows server 2003. when I execute command in first, the bcp run successfully but when I run[详细]
2022-12-20 16:10 分类:问答Easy way to inspect BCP .dat file?
I\'m getting BCP error \"Unexpected EOF encountered in BCP data-file\" during import, which is 开发者_如何学运维probably misleading. I strongly suspect that some field has been added to the table or t[详细]
2022-12-20 13:44 分类:问答Create a file in Java for loading into an nvarchar field in SQLServer 2005 using BCP and UTF-16
I want to use BCP to load into a SQL Server 2005 table with an nvarchar field using a loader control file.As I understand it, SQL Server 2005 only supports UTF-16 (and I believe it is UTF-16 LE).The f[详细]
2022-12-20 09:10 分类:问答Bulk insert XML data into SQL Server
Using the table structure below how would I create a bcp 开发者_如何学JAVAbulk insert that would handle the XML data.It is important that this is run from command line.[详细]
2022-12-20 08:51 分类:问答Rollback for bulk copy
I have an application开发者_如何学Go that make a copy from my database by bulk copy class in c#.[详细]
2022-12-19 22:36 分类:问答