SqlBulkCopy Tutorial - Knowledge Base (KB)

Select into statement where source is other database

How to copy data from one DB into another DB with the same table structure and keep the key identities?...I use Sql Server 2012 "Denali" and I want to copy some data from a Sql Server 2008 DB. The tables I have are exactly the same but I want the data fro...

Persistent time out issues copying very large tables across SQL Server 2012 instances on Amazon RDS

To give some context, I'm currently running a SQL Server 2012 instance on Amazon RDS and I've had to move to a larger instance twice already. The first time SQLAzureMW was the way to go, but at the time no table was that significantly large. The second ti...

Determine Security Differences Between Two SQL Servers Database Users

We're running SQL Server 2012 / .Net Framework 4.5.1...We have an application that does the following:...Extract all table data from a source database using an instance of .Net's ...SqlBulkCopy.......Delete all data in a target database using regular SQL ...

SQL Server Alternative to reseeding identity column

I am currently working on a phone directory application. For this application I get a flat file (csv) from corporate SAP that is updated daily that I use to update an sql database twice a day using a windows service. Additionally, users can add themselves...

string filed is truncated on SqlBulkCopy insert

I use SqlBulkCopy to insert excel data to table....One of the fields is ntext on the destination table but when the data is inserted the data is truncated after 255 chars....using (OleDbConnection conExcel = new OleDbConnection(connstring)) ...

How do I capture the data passed in SqlBulkCopy using the Sql Profiler?

I am using Sql Profiler all the time to capture the SQL statements and rerun problematic ones. Very useful....However, some code uses the SqlBulkCopy API and I have no idea how to capture those. I see creation of temp tables, but nothing that populates th...

SQLBulkCopy with CLR UDT gives "Could not find method 'Read' for type 'MyNamespace.MyType' in assembly 'MyType'"

I have written a SQL Server CLR User-defined type (UDT) in SQL Server 2012. I have been able to access it though SQL test scripts, and have used it as a local variable, defined it in a table, and tested it through Visual Studio and SQL Server Management S...

Microsoft SQL BCP Format File - Version?

I have a question regarding Microsoft SQL's Bulk Copy Program (BCP.exe). I am relatively new to using the program so am hoping it's an easy question for some, however I am stuck!...On Server #1 we're running Microsoft SQL 2014, it runs the BCP to export a...

How to copy only modified columns for all rows of table 1 into table 2 in sql server 2014

I have 2 tables table1 and table2....Initially table1 have some data and table2 is blank table having same column structure(Replica)....I have copied all data from table1 to table2 at first. now after few days ,some columns of few rows get modified in ta...