<div>
From my understanding (which could be wrong), bcp will always have problems (parallel or not) if rows are inserted during the operation.
</div>


From my understanding (which could be wrong), bcp will always have problems (parallel or not) if rows are inserted during the operation.

<div>
I have similar problem and I used a range (suppose 50000 records) of Identity(Unique) column to create the view and bcp out the view data.
</div>


I have similar problem and I used a range (suppose 50000 records) of Identity(Unique) column to create the view and bcp out the view data.

<div>
<div class="content wysiwyg-content">
Hi Sybase-Experts!<br />
<br />
We a searching for a safe possibility to bcp-out a big data table on Sybase ASE-15.0.<br />
Although it's not recommended (concerning several websites), but nevertheless we tried already a parallel bcp-out with separate chunks via -F and -L options and got a good performance boost by that.<br />
But unfortunately there happen several inserts on the table during bcp.<br />
So some rows are written out twice (in adjacent bcp-out blocks) and others (with highest row count) get lost.<br />
<br />
Do you have any idea how to make this parallel bcp-out more reliable or have another better parallel-bcp approach?
</div>
</div>


Hi Sybase-Experts!

We a searching for a safe possibility to bcp-out a big data table on Sybase ASE-15.0.
Although it's not recommended (concerning several websites), but nevertheless we tried already a parallel bcp-out with separate chunks via -F and -L options and got a good performance boost by that.
But unfortunately there happen several inserts on the table during bcp.
So some rows are written out twice (in adjacent bcp-out blocks) and others (with highest row count) get lost.

Do you have any idea how to make this parallel bcp-out more reliable or have another better parallel-bcp approach?

Sybase BCP parallel

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

Big data describes data sets that are so large or complex that traditional data processing applications are inadequate. Challenges include analysis, capture, data curation, search, sharing, storage, transfer, visualization, querying and information privacy. The term often refers simply to the use of predictive analytics or certain other advanced methods to extract value from data, and seldom to a particular size of data set.