zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

9 results for: in tag: sql-server-2012

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...
sql sqlbulkcopy sql-server sql-server-2008 sql-server-2012
asked by Marthin

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...
smo sqlbulkcopy sql-server sql-server-2012 ssis
asked by Alton XL

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 ...
sqlbulkcopy sql-server sql-server-2012 ssms tsql
asked by bopapa_1979

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...
database sqlbulkcopy sql-server sql-server-2012
asked by Carel

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)) ...
c# excel sqlbulkcopy sql-server-2012
asked by eyalb

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...
bulkinsert sqlbulkcopy sql-server sql-server-2012 sql-server-profiler
asked by mark

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...
sqlbulkcopy sqlclr sql-server sql-server-2012 user-defined-types
asked by RonSanderson

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...
bcp sql sqlbulkcopy sql-server-2012 sql-server-2014
asked by Zachary

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...
sqlbulkcopy sql-server sql-server-2012
asked by Vishal Pawar

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...