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 prefer not to be calling any Process.Start calls to open up command prompts to call bcp.exe. ...
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. Source table has a large xml content in of the rows, about 2.5Mb. I saved the content of the xml column into a file, see map.zip attached or download it from https://docs.google.com/leaf?id=0Bz4PXXE...
Can SqlBulkCopy create a table, kind of like a SELECT INTO? ...
I need to selectively (both rows and columns) export around 20 million rows from one table to another. This is what I tried: --Run this in batch: INSERT INTO Table 2 Select A, B from Table1 where A > a and B < b ---Table1 have columns A, B....Z and got around 50 million records. It takes around 12 hours to finish. I don't think syb...