sqlbulkcopy
SQL Server .NET SqlBulkCopy class keep running after exception
I\'m inserting lot of data with a SqlBulkCopy. The source of the data may have some duplicated rows. I the destination table I have an index of uniqueness.[详细]
2023-01-24 04:36 分类:问答bulk copy - sybase
I need to selectively (both rows and columns) export around 20 million rows from one table to another. This is what I tried:[详细]
2023-01-22 14:22 分类:问答Can SqlBulkCopy create a table from a Sql selection
Can SqlBulkCopy create a table, k开发者_JAVA百科ind of like a SELECT INTO?I think answer above wasn\'t quite clear.[详细]
2023-01-20 18:21 分类:问答SqlBulkCopy fails trying to copy a row with large content in an XML column
I am trying to copy a record from one SQL Server table to another. Both tables have the same structure, one of the columns is of type xml.[详细]
2023-01-20 00:44 分类:问答How to bulk copy sql (export) tables to a csv or tsv files in .Net?
Are there any .Net libraries that provide a way of exporting sql database data to plain text files (i.e. csv\\tsv)? SqlBulkCopy only applies to the import part of the solution and I p开发者_C百科refer[详细]
2023-01-19 23:17 分类:问答Can I use sql bulk copy to copy data within the same server?
Can I use sql bul开发者_如何转开发k copy to copy data within the same server ?Yes. In fact, in the demo code shown here, they copy to a table within the same database.[详细]
2023-01-19 15:38 分类:问答Skip some columns in SqlBulkCopy
I\'m using SqlBulkCopy against two SQL Server 2008 with different sets of columns (going to move some data from prod server to dev). So want to skip some columns not yet existed / not yet removed.[详细]
2023-01-17 15:37 分类:问答Error handling with SqlBulkCopy - could it be any harder?
Running very low on ideas here. I\'ve got a case where I\'m using SqlBulkCopy to pump data into a DB, and about halfway through I run into different exceptions (primary key violations, index violation[详细]
2023-01-09 06:58 分类:问答Fast insert relational(normalized) data tables into SQL Server 2008 database
I\'m trying to find a better and faster way to insert pretty massive amount of data(~50K rows) than the Linq that I\'m using now.[详细]
2023-01-03 01:33 分类:问答Why this strange behavior of sqlbulkcopy in a asp.net website running under iis?
I\'m using SqlClient.SqlBulkCopy to try and bulk copy a csv file into a database.I am getting the following error after calling the[详细]
2023-01-02 03:46 分类:问答