sqlbulkcopy
Is there a way to use SqlBulkCopy without converting the data to a DataTable?
Is there a way to use SqlBulkCopy without开发者_运维技巧 converting the data to a DataTable? I have a list of objects (List) in RAM and I really don\'t want to use more memory to create the DataTable.[详细]
2022-12-12 10:12 分类:问答SQLBulkCopy connection errors when working with SQL Azure
We are currently trying out the SQLBulkCopy API on the new SQL Azure CTP. While we have been able to consistently migrate tables with about a million rows, we are facing connection errors when workin[详细]
2022-12-12 08:30 分类:问答Using SQLBulkCopy to Insert/Update database
I have a datatable with the records.I\'m inserting records into Sql table using SqlBulkCopy.It works fine.Next time when get the datatable with same records with few changed values SqlBulkCopy is inse[详细]
2022-12-11 02:14 分类:问答ODBC and Windows Service
I\'m new to windows services and... you guessed it, I’m a bit stuck. Let me paint the picture – I’m running a timed service that use an OdbcDataReader and SqlBulkCopy to (1) archive the data (2) n[详细]
2022-12-09 17:04 分类:问答Is it possible to use SqlBulkCopy in SQL 2008 without permission 'db_datawriter'?
I want to limit my database possible access ways to only using stored procedures. Everything works fine except System.Data.SqlClient.SqlBulkCopy. I\'m using it only in one class for massive data impor[详细]
2022-12-09 15:00 分类:问答SqlBulkCopy refuses to convert String.Empty into INT NULL
Recently I\'ve been tasked with creating an automated ETL process that pumps the data into tables based on the flat file name by reading a master mapping file. I\'ve decided to go with SqlBulkCopy and[详细]
2022-12-09 13:31 分类:问答Bulk Copy from SQL Server to Oracle
I have a requirement for a project to move data from SQL Server to Oracle in bulk mode. There is OracleBulkCopy from DataDirect and ODP .net开发者_运维知识库 but to use that I have to first convert th[详细]
2022-12-09 04:28 分类:问答sqlbulkcopy using sql CE
Is it possible to use SqlBulkcopy with Sq开发者_Go百科l Compact Edition e.g. (*.sdf) files? I know it works with SQL Server 200 Up, but wanted to check CE compatibility.[详细]
2022-12-08 23:28 分类:问答